Newbies dougshade Posted June 6, 2006 Newbies Share Posted June 6, 2006 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 More sharing options...
Recommended Posts
This topic is 6533 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 accountSign in
Already have an account? Sign in here.
Sign In Now