Newbies bishop7262 Posted May 14, 2016 Newbies Share Posted May 14, 2016 I have a table with field Trainer_Location and Trainer_Name. I want to be able to choose from field Trainer_Location (Club1, Club2, Club3 or Club4) and have the next field Trainer_Name show the related trainer's name. So example: Example 1 Trainer Location: Club 1 Trainers Name: John, Jason, Mike Example 2 Trainer Location: Club 2 Trainers Name: Julie, Todd, Don, Fran Link to comment Share on other sites More sharing options...
Lee Smith Posted May 14, 2016 Share Posted May 14, 2016 Hi bishop and welcome to the FM Forums, You are describing a Conditional Value List. See this if this recent post helps. Lee Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2904 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