Access auto fill/populate field with list of different values

[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

[John Vinson]

On 15 Jul 2003 08:42:17 -0700, [email]lumiya@yahoo.com[/email] (Michael) wrote:

>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.

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.

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]