Jump to content

Select from only a Subset of Related


This topic is 5664 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

This topic is 5664 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.