Data

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

Hi
Is it possible to Join two tables have and have a field from the second
table show in a form ?
If so could you please point me in the right dirction

thanks

Kevin
 
kevin carter said:
Hi
Is it possible to Join two tables have and have a field from the second
table show in a form ?
If so could you please point me in the right dirction
Click to expand...

You start by creating a query that joins the two tables on the related fields. You
can then include fields from either or both tables in the output of the query. Then
base your form on the query. Forms don't care whether they are bound to a query or a
table.

You should realize though that if the tables have a one-to-many relationship that
data on the one-side table will be repeated for each matching record in the many-side
table. Often in forms, this is not what you want. In those cases a form bound to
each table and placing the many-side form into the other form as a subform is the
usual approach.
 
THanks for help
Rick Brandt said:
You start by creating a query that joins the two tables on the related fields. You
can then include fields from either or both tables in the output of the query. Then
base your form on the query. Forms don't care whether they are bound to a query or a
table.

You should realize though that if the tables have a one-to-many relationship that
data on the one-side table will be repeated for each matching record in the many-side
table. Often in forms, this is not what you want. In those cases a form bound to
each table and placing the many-side form into the other form as a subform is the
usual approach.
Click to expand...
 
Back
Top