Tables 1

[zyphac]

Hello again, here is a question dealing with tables. I have a form that has A buyer annd a seller text boxes, along with their address. (and few other ones) Here what trying to do I need the buyer and seller saved in my tblmain, i don't want the address there, but I need for them to come back when I load my form up and search past records, other wise I will have hundreds of repeat addresses in my table. I have it set up where you click on a button and my customer form comes up(brings the data from my clients table)and you select which one you want. Same with the seller. Then by code, the select button sends the data right along to my txt boxes(name, address, city, state, zip)I sorry if this worded wrong, its 3am here, I need to sleep hhehe. If I need to be clear I will do so in the morning, after a few hours of sleep : )
Thank you
tired zypha

 

[WildHare]

You need to be sure your two tables are normalized correctly. Basically, you have a table of "clients" (whom I assume can/will be either buyers or sellers?) In this table, you will store the name, address,phone, and any other pertinent details which are specific to a client.

Then you have another table of "transactions", if you will, between a 'Buyer', and a "Seller" , both of whom, one would hope, will exist as 'clients' in your other table. You will use a ClientID key of some type as your linking field - just store the ClientID value in your transactions table. It can then be used to LINK back to the Clients table in a query, and pull any of the other client info like address, phone, etc when you need it.

To reiterate, the ONLY information that is being entered more than one time is the CLIENT ID on the transactions side.

Does this help at all?

Jim
Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[zyphac]

Yes it does help, I was try to make light of it last night and my brain, just wouldn't let me, hhehe, thank you well spoken. I was not sure that I explained myself correctly, You nailed it, thanks

Zypha