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
|
|||
|
|||
which data in which table
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 |
#2
|
|||
|
|||
which data in which table
If the fields are specific to item and vendor, put them in tblItemVend.
-- Duane Hookom MS Access MVP -- "Boze" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |