K
KR
Can someone please help me???
Please see my information I am working with below to understand what the
heck I am talking about.
I want a form that will allow me to:
-Search for a doctor
- Display all of the doctors implant records
- be able to select a specific study for that doctor and have it
show me all of that doctors implants for that study (their are 8 studies each
record belongs to one of the 8 studies)
Here are the tables I have and the information I am working with.
Table 1: USImplants
Fields:
Cardnumber
ProductN
LotN
SerialN
Study (Aa, Bb, Cc, Dd, Ee, Ff, Gg, Hh)
Last Name (This is the Doctors Last Name)
First Name (This is the Doctors First Name)
Site Name
Table 2: USDoctors (this table has a list of all of the doctors names with
no duplicates)
Fields:
ID (Autonumber)
LastName
FirstName
Table 3: Devices (Not sure if I need this table or the US Doctors table)
ID (Autonumber)
Devices (Aa, Bb, Cc, Dd, Ee, Ff, Gg, Hh)
If someone can help me you are a genius and I appreciate it so much....my
brain is starting to hurt and I can't think anymore
Please see my information I am working with below to understand what the
heck I am talking about.
I want a form that will allow me to:
-Search for a doctor
- Display all of the doctors implant records
- be able to select a specific study for that doctor and have it
show me all of that doctors implants for that study (their are 8 studies each
record belongs to one of the 8 studies)
Here are the tables I have and the information I am working with.
Table 1: USImplants
Fields:
Cardnumber
ProductN
LotN
SerialN
Study (Aa, Bb, Cc, Dd, Ee, Ff, Gg, Hh)
Last Name (This is the Doctors Last Name)
First Name (This is the Doctors First Name)
Site Name
Table 2: USDoctors (this table has a list of all of the doctors names with
no duplicates)
Fields:
ID (Autonumber)
LastName
FirstName
Table 3: Devices (Not sure if I need this table or the US Doctors table)
ID (Autonumber)
Devices (Aa, Bb, Cc, Dd, Ee, Ff, Gg, Hh)
If someone can help me you are a genius and I appreciate it so much....my
brain is starting to hurt and I can't think anymore