Multiple Table fields in the same form

[Guest]

Question: Is there a way to place fields from two tables into one form and
have it where the results (data entered) will go to the correct table.

I have two different tables, one called Candidate and the other one called
CandidateProgress.

In my Candidate table I have a field called "Received Transcript". I would
like to place this field in my form called CAndidateProgressForm. Now that
form has all the fields that are in my CandidateProgress Table but the only
field that will not be in same table will be the "recived Transcript" where
the results should go back to my Candidate Table.

Now in my form the control source is just the name of the field but that
only refers to the table that the form was made from.

Is there a way to refer to my Candidate.ReceivedTranscript from the form
called CandidateProgressForm?

I hope this makes sense.

 

[Guest]

You will want to use a Form/Subform construct for this.
Make the record source for the form the Candidate table.
Create a subform control with the link master/child tables property set to
relate the Candidate to the CandidateProgress table.
Create a form for the CandidateProgress table that will be the Source Object
for the subform.