Way to create Value list based on a number of fields and their values
Trying to figure out how to limit a drop down (or pop-up) to limit the items that can be selected by a number of fields. Table I have are “Tour”, “Hotel”, HotelDates”, “Names”, “Tourer”, and “MemberTours”.
Tour Table contains a Tour Code.
Hotel is linked to Names for the name of the Hotel (Names::Company)
HotelDates contains a “Booked” field set to Y/N to designate if the hotel is booked for a specific TourCode.
What I need for a layout using MemberTours is a way to choose from a drop down of only Hotels that are booked (Booked field = Y) for the TourCode that this Member is on.
I hope that makes sense. I'm still pretty new to FM. I've tried creating TOs and all kinds of things, but this one is eluding me.