DWUTKA at marlow.com
DWUTKA at marlow.com
Mon Mar 15 15:28:27 CST 2004
I would say the PO table, since those terms would be unique to the PO. If you want to get fancy, you could remember the Vendor's or Buyer's preferences, and use that as a default for a new PO. 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 11:48 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Vendor Table Ok, that makes sense. Where would the Payment Terms, Ship Via, Freight Terms go - which table? Virginia -----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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com