Access auto fill/populate field with list of different values

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I am creating a database with the following fields in the table

ID - ID Number for person
LAB - Lab Name
LABDT - Lab date
LABVAL - Value of the lab

I have a list of about 15 different labs for each person. When the
user goes to enter data on the form, I want the form to look something
like the following

LAB LABDT LABVAL

Hemo
Plate
NA
K


Which will make the data in the tables look like

ID LAB LABDT LABVAL
1 Hemo 1/1/2001 1.0
1 Plate 2/1/1/2001 5.0
1 NA 1/5/2001 10.1
1 K 2/2/2001 5.4


I want the Lab field to be specified by the form so that the user only
has to enter the labdt and labval.

How do I do this in access 2000?

Thanks
 
I am creating a database with the following fields in the table

ID - ID Number for person
LAB - Lab Name
LABDT - Lab date
LABVAL - Value of the lab

I have a list of about 15 different labs for each person.
Click to expand...

Does the list vary from person to person, or is it standard?
...

I want the Lab field to be specified by the form so that the user only
has to enter the labdt and labval.
Click to expand...

You could base the Subform on a Query joining the list of standard
labs (or a Query selecting that patient's labs) to the Results table
by the test ID using a Left Join - "show all records in StandardLabs
and matching records in Results". Be sure to include the LabID field
from the Results table in the query. Now if you enter the labdt and
labval, Access will fill in the LabID.
 
Back
Top