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
|
|||
|
|||
Creating a Database and having problems
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. |
#2
|
|||
|
|||
On Wed, 2 Mar 2005 14:53:02 -0800, Jesica
wrote: 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] |
#3
|
|||
|
|||
John Vinson wrote:
On Wed, 2 Mar 2005 14:53:02 -0800, Jesica wrote: 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 example: Vendor: Joe's Glass Category: Glass Repair Window Replacement You need *three* tables to do this: Vendors; Categories; and VendorCategories. 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. -- |
Thread Tools | |
Display Modes | |
|
|