Form to populate multiple tables

[sambrierley]

Hi,

should be a pretty simple solution for someone that knows what theyre doing

I have 2 tables
i've created a form based on Table 1.
Table 1 and Table 2 have a relationship.
i want to put a text box with data from Table 2 on the form.

Structures.
Table 1:
[Doc ID], [Requirement], etc

Table 2:
[ID], [Path], etc

where the Doc ID in Table 1 has a many to one relationship with ID in Table 2. Path is the field i want to show on the form.

im sure SQL in the source is the answer but im not sure how to achieve it.
thanks

 

[CJ_London]

create a form for table 2, then drag it onto the table1 form to create a subform control. Ensure the subform control linkchild and linkmaster properties are completed - linkmaster will refer to the table2 field which defines your relationship and the linkmaster the table2 field in your relationship

 

[sambrierley]

Thanks this does work although doesnt look all that neat.

For future readers a miles better looking option is to create the subform as instructed above. Then size it to be tiny and hide it somewhere.

There is a function within the control property that allow filed from other table. this will only work when the subform exists.

a much better presented solution to my problem.

thanks for the help