Hollis,Virginia
HollisVJ at pgdp.usec.com
Sat Mar 13 10:45:43 CST 2004
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