Arthur Fuller
artful at rogers.com
Mon Mar 15 15:32:22 CST 2004
I'll toss in my $.02 here, SSH.... You assume that a given entity cannot be a Buyer, a Requestor and a Vendor simultaneously, or any two of same. I'd go with preserving most of your notion -- placing them all in a single table -- and attach to that a child table (or alternatively three yes/no fields) depicting the entity type. If we are guaranteed that there will emerge no new entity types in the forseeable future, the columns will be quicker. If at any moment there might emerge a new entity type, then I'd go with the child table. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Saturday, March 13, 2004 8: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