DWUTKA at marlow.com
DWUTKA at marlow.com
Mon Mar 15 15:44:41 CST 2004
Virginia, I think you are confusing Vendor with Purchase Order. A Vendor is just a peice of a Purchase Order, not the other way around. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Hollis,Virginia Sent: Saturday, March 13, 2004 10:46 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Set up tables - Please Help tbl_Vendor contains all the data for the vendor; address, company name, etc. tbl_VendorMain could really be named tbl_RequestMain. tbl_VendorMain is where I thought I would store the combination of the data - VendorID, ContactID, BuyerID, RequestorID, DateRequested. -----Original Message----- From: Susan Harkins [mailto:ssharkins at bellsouth.net] Sent: Saturday, March 13, 2004 10:38 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Set up tables - Please Help What's the difference between tbl_Vendor and tbl_VendorMain? Susan H. I have one table for each - tbl_Buyer, tbl_Contacts, tbl_Requestor, tbl_TypeBusiness, tbl_Vendor, tbl_VendorMain, tbl_Accounts. Tables buyer, vendor contacts, requestor store just the typical name, phone number, etc. -- _______________________________________________ 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