junction table design. Records won't fill

[Lifeseeker]

Hi,

I think I have been struggling with this for so long.
In the attached database, there are only less than 5 records, but I'm trying to find out why this field won't fill itself as you pick from master table....

3 tables in total. Lab, test approvals and record table. Reason for 3 tables is because a lab can have multiple tests, but the same test can belong to multiple labs.

In the record table, I am simply picking the combination of lab and test approvals. My question is....how come the test description doesn't get filled in automatically as you pick from the test approval dropdown?

Did I do anything wrong here?

 

[Jeanette Cunningham]

To design a form for entering data into a 3 table many-to-many relationship, I find that this works for me.
Create a main form based on one of the One - side tables.
Create a subform based on the junction table.
On the subform put a combo where user can choose a value from the remaining One - side table to populate the subform.