Linking a field (not a subform)

[EastCoast]

<b>The Setting:</b> I have a "Classes" form and an "Evaluations" form whose underlying tables are 1 (Classes) to Many (Evaluations). The Classes form has its own subform and the Evaluations form has its own subform.

<b>What I would like:</b> is to click on a button on the Classes main form and have it take me to the Evaluations form - that I can do, but when I get to the Evaluations form I need it to know somehow that it belongs to the specific class record I just came from before I clicked. Foro example, if I am entering the class "Conflict Management" and then click on the button to go to the "Evaluations" form, I want a field there to tie it back so that it knows these evaluation scores belong with the "Conflict Management" class.

<b>What I've done:</b> I have tried placing the "ClassID" field (the foreign key, since it is the primary key in the Classes table) onto the Evaluations table, but I do not know how to link it back to the classes table so that it automatically populates the ClassID for the particular class that was on the previous screen (the class I was entering before clicking on the button to go to the Evaluations form). Make sense?

 

[ItIsHardToProgram]

You need to load your form with a query that will do this for you.....

inner join probably

 

[ItIsHardToProgram]

Actually not a inner join but more of a left join, any way you can do this via your access window.... I would personaly get the value from a recordset and have it populate in your form....