Access Lookups

C

coyoteservices

I need to have an access form that allow the user to firstly select a
company (from table 'COY') and the have a list of locations (from table
'COY_LOC').

So when he selects a company i.e 'Freds Windows' he then gets a list of
all the locaions for Freds Windows.


I then will need to write the loction to another table with the date,
etc.

Thanks for any help

Mat
 
J

John Vinson

I need to have an access form that allow the user to firstly select a
company (from table 'COY') and the have a list of locations (from table
'COY_LOC').
Click to expand...

Well... I'd reconsider that design. If you have one table FOR EACH
COMPANY, you're making a bad mistake. Storing data in table names is
*never* good design.
So when he selects a company i.e 'Freds Windows' he then gets a list of
all the locaions for Freds Windows.
Click to expand...

Instead, consider a Locations table with a field for the company name.
You can then use the "cascading combo boxes" suggestion in the other
response in this thread to select only locations for that company.
I then will need to write the loction to another table with the date,
etc.
Click to expand...

You only need one form to do this; have it bound to the target table,
and have two combo boxes for the Company and the Location
respectively.

John W. Vinson[MVP]
 
Top