I am designing a database for a clinic's dispensary (pharmacy). There are actually various issues I need to resolve, being that I have no experience whatsoever. I'll let you know what I've done so far and list my major issues below.
TABLES:
I have 3 tables: "Basic Patient Info" (P), "IDP Orders" (O1), and "CCH Orders" (O2). The first has chart numbers, names, address, and so on. The second and third also have the chart numbers, as well the order dates, medications and so on, which have been made on patient's behalf to IDP and CCH (different suppliers). The three tables are linked by the patient's chart number.
QUERIES:
I have various queries. The first, and most important, was designed to pull up a patient's basic info, and orders by chart number, last name, and/or first name OR any partials of these. Also I have queries to pull IDP orders between certain dates and CCH orders between dates. The queries work well.
FORMS:
I need to make a patient info and orders form split into three compartments: One should contain the basic info from table P. One should have all the IDP orders for that patient from O1. And the third should be his/her CCH orders from O2. I used the wizard and made a table with the basic info, and the orders. However [PROBLEM 1], if there is more than one order for the same patient, than queueing that patient's info returns two records, both with the same basic patient info but different order info.
I also have a switchboard with a link to each form. More questions to come...
I apologize for asking what is likely a very basic question, but your help is super appreciated.
Sincerely,
Andy
TABLES:
I have 3 tables: "Basic Patient Info" (P), "IDP Orders" (O1), and "CCH Orders" (O2). The first has chart numbers, names, address, and so on. The second and third also have the chart numbers, as well the order dates, medications and so on, which have been made on patient's behalf to IDP and CCH (different suppliers). The three tables are linked by the patient's chart number.
QUERIES:
I have various queries. The first, and most important, was designed to pull up a patient's basic info, and orders by chart number, last name, and/or first name OR any partials of these. Also I have queries to pull IDP orders between certain dates and CCH orders between dates. The queries work well.
FORMS:
I need to make a patient info and orders form split into three compartments: One should contain the basic info from table P. One should have all the IDP orders for that patient from O1. And the third should be his/her CCH orders from O2. I used the wizard and made a table with the basic info, and the orders. However [PROBLEM 1], if there is more than one order for the same patient, than queueing that patient's info returns two records, both with the same basic patient info but different order info.
I also have a switchboard with a link to each form. More questions to come...
I apologize for asking what is likely a very basic question, but your help is super appreciated.
Sincerely,
Andy