Data

[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

 

[Rick Brandt]

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

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.

 

[Kevin Carter]

THanks for help

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.