Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking 2 forms with different tables

Status
Not open for further replies.

TheBeginner

Programmer
Jun 25, 2003
10
GB
I would like to link 2 forms that come from different tables, i have linked their relationships.

how would i do this?
 
Now forgive me if I'm completely wrong, but this is one thing I've never tried! But I believe you would have to do it via a query.

Use a query to pull in the fields from the two tables, then create a form based on that query.

I think. :)
 
What do you mean "LINK FORMS"???
John
 
Do you mean link a subform and a form?

Do you want records to match one another according to an id number?
 
I have a form called members and another called doctor, i want each members doctors details to appear on a separate form as one member may have the same doctor as another member.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top