Creating a Database and having problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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]
 
John said:
You need *three* tables to do this: Vendors; Categories; and
VendorCategories.
Click to expand...

Do a google search for "Standard Industrial Classification" or "SIC
codes".

My quick search turned up the following:

1793-03 Glass-Repairing
1751-05 Window Replacement

Next, find out the number of SIC codes a business may be assigned. If
the answer is small (say, four), it may be better to model as a fixed
number of attributes columns in your Vendors table.

It always pays to do research <g>.

Jamie.

--
 
Back
Top