AnsweredAssumed Answered

Way to create Value list based on a number of fields and their values

Question asked by JimBessette on Nov 17, 2013
Latest reply on Nov 18, 2013 by JimBessette

Title

Way to create Value list based on a number of fields and their values

Post

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.

Jim

Outcomes