[AccessD] Set up tables - Please Help

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



More information about the AccessD mailing list