Hollis,Virginia
HollisVJ at pgdp.usec.com
Sat Mar 13 06:58:52 CST 2004
Would this be correct? tbl_VendorMain VendorID ContactID RequestorID BuyerID TypeID DateRequested tbl_Vendor VendorID Vendor info stuff tbl_Type TypeID Type stuff etc. OR Should tbl_Vendor have CustomerID? -----Original Message----- From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] Sent: Friday, March 12, 2004 10:17 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Vendor Table Sounds like a PO system. The PurchaseOrder table would be the 'tie in'. You would have a PO Number, then a buyerID, VendorID, and your items. Depends on how complex you want to make it, you should probably have a PO Line Items table. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Hollis,Virginia Sent: Friday, March 12, 2004 9:01 AM To: 'accessd at databaseadvisors.com' Subject: [AccessD] Vendor Table I am starting a new database - that seems fairly standard, but it is my first time with this type.... This database is to track vendor information & requests. I know I need a table with vendor information, one for the buyer, & one for contacts. The problem is I can't think of how to tie them all together, especially the buyer & requestor with the vendor. The buyer completes the form with all the vendor information, regular fields - name, address, terms. I guess my question is what do I put in a Main? table to tie all the information together? It is mostly just a form completed by the buyer and sent to another department for entry into the suppliers database. But the 2nd department wants to track the requests (where I come in). Virginia -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com