Hollis,Virginia
HollisVJ at pgdp.usec.com
Sat Mar 13 10:56:54 CST 2004
Ok, I will send off line so it doesn't take up room & attachments on the list. -----Original Message----- From: Susan Harkins [mailto:ssharkins at bellsouth.net] Sent: Saturday, March 13, 2004 10:47 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Set up tables - Please Help Virginia -- I'm assuming all those ID fields are foreign keys. Can you send a shot of your Relationships window? Should tbl_VendorMain really be a query? I'm not sure what new data you're actually storing -- looks like just that DateRequested. Susan H. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,Virginia Sent: Saturday, March 13, 2004 11:29 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Set up tables - Please Help 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. tbl_TypeBusiness is one that confuses me - I need it linked to tbl_Vendor so when you select the vendor the different types are selected. A vendor can be any combination of 15 different types. When I set up tbl_VendorMain with: RequestID TypeID VendorID ContactID BuyerID RequestorID DateRequested. Then join everything to this table, I get data on my form. But if I divide it out the way I thought it should be, and join tbl_Buyer & tbl_Requestor to tbl_VendorMain. Then tbl_VendorMain to tbl_Vendor by RequestID & tbl_Contacts to tbl_Vendor by VendorID I don't get any data in the form. To say the least - I have made a mess of it all. Virginia -----Original Message----- From: Susan Harkins [mailto:ssharkins at bellsouth.net] Sent: Saturday, March 13, 2004 10:05 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Set up tables - Please Help Virginia, is the data basically the same for everyone? What kind of data are you storing for each buyer, requestor, and vendor because you could just dump them all in one table and then flag each as a buyer, requestor or vendor using some kind of id value. That's one way to go. Or, you could have a separate table for each -- and you should if the data is significantly different for each to avoid all those blanks where data doesn't apply to one type. So, do you have a separate table for the following as well: contracts, business type, and account type? The two latter sound like classic lookup tables. Susan H. Can someone please help me - I am having the hardest time setting up my tables for this new vendor program. I have tried making a main vendor table but when I try to put the data all together, my form is blank and you can't add any records. I am so frustrated with this whole thing. I keep telling myself it shouldn't be this hard! A request has a buyer, requestor, and a Vendor. A Vendor has a contact, type of business, and an account type. Sounds so easy.... well, every way I try I get ZERO data. 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 -- _______________________________________________ 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