DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Mar 16 13:59:28 CST 2004
I think I really need to take a look at what you are trying to do. Can you send it to me offlist? I won't have a chance to look at it until later this week, or on the weekend. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Hollis,Virginia Sent: Tuesday, March 16, 2004 6:28 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Set up tables - Please Help This is all taken from a hard copy of the current request form. The buyer completes the vendor request form with the vendor information. The form is used to add the new vendor information into a main database. The form provides the vendors name, billing information, type of business, etc. It does not list any items the company will buy from this vendor. Once the vendor information is added, then the company will issue POs, contracts to the new vendor (not part of this database). They just want to track the requests from the buyers. The form contains a lot of information about the vendor. When I create all the tables and join them to create a form for entering the information, it either comes up blank (no records) or I can't add any new records, one try it kept knocking my query out - I think because it was too long. Virginia -----Original Message----- From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] Sent: Monday, March 15, 2004 3:45 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Set up tables - Please Help 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 -- _______________________________________________ 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