Susan Harkins
ssharkins at bellsouth.net
Sat Mar 13 11:02:37 CST 2004
By "store the combination of the data" are you saying that the data is already stored in other tables and you're just pulling it into a new table? Could DateRequested by stored in tbl_Request? Is there a tbl_Request? Susan H. 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