Relating Tables

[Geneva Anderson]

I have designed a table of contractors. I have designed a table of
specialties as well as a third contractor specialties table and all 3 tables
are linked. Now, how do I add specialties to a particular contractor so that
when I search for "Interior Decorator in Des Moines, Iowa" I can find the
contractor with the specialty that I need? Is this done through a form with
a subform? I need capability to add multiple specialties to one contractor.

Thanks for any help.

 

[Larry Daugherty]

You might use a form/subform paradigm to enter and manage the
assignment of specialties to contractors. The main form would be
based on tblContractor and the subform on tblContractorSpecialty.

I'd use a combobox in the header of the main form to find the
contractor record to work on. The combobox wizard will help you, tell
it "go to a particular record".

The subform should have a combobox based on tblSpecialty. Choosing a
specialty will create that record. To add another specialty just step
to the new record in the subform and select another specialty.

You can search for and get a list of contractors in a particular city
with a particular specialty.

HTH

 

[Geneva Anderson]

Thanks. I will give this a try. Surely appreciate your help.