Multiple tables in one form

[cpgoose]

Hi folks, any ideas would be great....

Say I have 3 tables, A, B, and C. I'm trying to create a form that will allow me to enter information into those 3 tables using 1 form. I'm having problems. Is there any kind of relationship that I have to define between the 3 tables to get this to work correctly?

Say I was inserting books for example. So the first row of Table A, B, and C would all relate to the first book. Each table just contains different information.

Any ideas would be great!

 

[PHV]

Take a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[cpgoose]

Thanks PHV, that was pretty good.

I think I'm having a problem with defining the relationships. If table A has a primary key, and table B has a primary key, do I just put the relationship between those two keys? Or should the relationship go from the primary key of A to a field in B?