[AccessD] Vendor Table

Hollis,Virginia HollisVJ at pgdp.usec.com
Fri Mar 12 11:47:57 CST 2004


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



More information about the AccessD mailing list