which data in which table

B

Boze

I'm not sure where to put a couple fields in my database. The database is
for info on our company items. I have 3 tables

tblItems
itemID
itemPartNumber (this is a # we give our products, not the same as the vendor
part #)
itemDescription
itemListPrice

tblVend
vendID
vendName
vendAddress
vendPhone

tblItemVend
itemID
vendID

my question.. since we give our items our own Part Number and the vendor has
THEIR part number in which table should I put
vendPartNum
vendPrice
it's specific to both the item and the vendor

If it matters.. I've got a form with tblItem info on the main form and
tblVend info on a subform.

Thanks in advance for the help
Boze
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

not quite clear on linking 2 (or more) to 1 4
table setup question 2
Table Design Still in Progress 1
Still designing, need help with Many-to-Many 12
HOW do I make selections and carry only those selections thru proc 5
Table design for database driven catalog 1
Which table to put fields in? 2
Table reference question 1

Top