|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 28th, 2009, 05:05 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Table Design
I have two tables. The first contains company names, addresses, phone and
fax numbers. The second table contains peoples names, cell phone numbers and emails. On the Contact form where you would enter a new person, I would like to have a drop down box listing all the companies in the companies table. I can't seem to get a lookup to work that lists the values in the first column of the companies table. Please Help!! Thanks in advance. -- chris 
|
|
#2
April 28th, 2009, 05:50 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Table Design
Create a query to pull the data, use the query as source for the drop down box.
"Chris" wrote: I have two tables. The first contains company names, addresses, phone and fax numbers. The second table contains peoples names, cell phone numbers and emails. On the Contact form where you would enter a new person, I would like to have a drop down box listing all the companies in the companies table. I can't seem to get a lookup to work that lists the values in the first column of the companies table. Please Help!! Thanks in advance. -- chris
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
