Select from only a Subset of Related

[dougshade]

I'm new to relational... so please forgive. This is probably an easy one.

I have a table, TEST REQUIREMENTS, and each record has a field called "Type" (say... types A, B & C)

I have a table, called TESTS. Tests can only be of type "Type" A, B & C.

So, when entering a new record into TESTS, I select Test Type... but then when it comes to what requirements are covered by the test, I want to limit the user to making choices from the TEST REQUIREMENTS table of only the matching type (e.g. A, B or C)

I understand how to make the relation between Tests and Test Requirements. I do no understand how to limit the relation to a matching type.

Any ideas on how to do this?