link form fields ??

[jus]

Office 2007 -

I'd like to add 2 fields to a form. The fields are 'company' and 'contact
person'. I'd like the user to have the option of filling out either field
from a drop-down and the one field automatically filled.

If the user selects the 'company' name from a drop-down, they are then
offered another drop-down of available 'contact persons' from that company.

Or, if they know the 'contact person' and select it from that drop-down -
the 'company' box is filled automatically.

So each completed form will have a 'company' and 'contact person'

I currently have a separate table for each 'company', each table holds the
selection of 'contact persons'. Should it be all in one table with the
information (company and contact persons)?

Does this make sense?

 

[Klatuu]

Having a separate table for each company is definitly wrong. You should have
one table with all companies with a field that identifies the company. As to
contacts, it depends on how much data you carry for a contact and on whether
a contact can be used for more than one company.