Susan Harkins
ssharkins at bellsouth.net
Sat Mar 13 10:04:36 CST 2004
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