One Form Three Tables

[yeatmanj]

I wish to use three tables to create a form. I can do this but the data is not editable. I want the data to appear in a row, with multiple records listed. The first table is the master table with two others as subs. The relationships are built and everything responds the way it should. This form has to be editable for me to accomplish what i want.

 

[Travis]

Use Sub forms for the Sub Tables. Use the parent/child linking in the subform property to link between the main and the subs.

 

[yeatmanj]

I know i can do use subforms to do what i want, but it doesn't present the data in the layout that i want to see it. I need it in one form or query that allows edits.

 

[Rich@ITTC]

If you do not want to do what Travis suggests (using SubForms) then maybe you should combine all three tables via one query. The form would then draw upon the query (but it could be a very "busy" form with all the fields from three tables).

HTH

Rich

 

[yeatmanj]

The solution was in front of my face the whole time.
The way i wanted to view the information caused me to need to pull the three tables into one query, but the query wasn't editable. Ok fine, finally i realized that I didn't need to edit from the query, and made a main form and 2 subs for the edits. I was just being narrow minded. But thank you for you r input.