G
Guest
Hi and thanks for the help. I am using Access 2003.
I have two tables. Here are the important fields for this question:
Table One: Client Number (primary key field), Client Name
Table Two: Client Number (used to relate the 2 tables), Order Date, Order
Amount
I would like to create a form that would work as a lookup. Nobody knows the
client numbers but we all know the client names. I would like to be able to
create a drop down box where I can select the Client Name from Table One and
populate the form with all of the associated fields and data from Table Two.
So when I select ABC Company from the dropdown I can see the client number,
order dates and order amounts.
Thanks for the help!
I have two tables. Here are the important fields for this question:
Table One: Client Number (primary key field), Client Name
Table Two: Client Number (used to relate the 2 tables), Order Date, Order
Amount
I would like to create a form that would work as a lookup. Nobody knows the
client numbers but we all know the client names. I would like to be able to
create a drop down box where I can select the Client Name from Table One and
populate the form with all of the associated fields and data from Table Two.
So when I select ABC Company from the dropdown I can see the client number,
order dates and order amounts.
Thanks for the help!