Creating a Database and having problems

[Jesica]

I have created a vendor database. It's basic, with the exception that I need
a field that allows me to choose more than one possible category and to
record this information in a table. I know this is possible, I just don't
know how to "program" it and it's driving me crazy.

example: Vendor: Joe's Glass
Category: Glass Repair
Window Replacement

Please help.
Thanks.

 

[John Vinson]

I have created a vendor database. It's basic, with the exception that I need
a field that allows me to choose more than one possible category and to
record this information in a table. I know this is possible, I just don't
know how to "program" it and it's driving me crazy.

example: Vendor: Joe's Glass
Category: Glass Repair
Window Replacement

Please help.
Thanks.

You need *three* tables to do this: Vendors; Categories; and
VendorCategories. The VendorCategories table would have the unique
VendorID as one field (don't use the vendor name, you can't be sure
it's unique) and the category as the other; if a vendor is in eight
categories, this table will have eight records for that vendor.

A Form based on Vendors with a Subform based on VendorCategories, with
a combo box on it bound to the Categories table, is a convenient way
to enter data into this structure.

John W. Vinson[MVP]