I'm having difficulty with a conditional value list that needs to pull up information from an initial related file, then another file related to that file. Here's the scenario:

Database 1: Client Information

Database 2: Vendor Information

Database 3: Vendor Contact Information (Some Vendors in DB2 have as many as 50 separate contacts).

I have a conditional value list set up based upon a relationship between 1 & 2 so that when a Client books at a Property (field populated using a pull down menu from Vendor Information database), I can then view/choose other information about that specific Property in the Client file. Trouble is that all of the contact information for DB2 (Vendor Information)is held in a 3rd file (i.e. Contact Name, Phone Number, etc.) and I can't seem to access specific contact information for the property I've chosen.

The reason this is necessary: each Vendor (DB2) can have as many as 50 separate contacts (DB3). Each Client (DB1) only books at one Property (DB2, then deals with up to 4 or 5 of the contacts (DB3) at that property. I would like to be able to populate a field in Clients with specific Vendor Contact Information based upon which property they book at. (i.e. reduce the list of 50 down to 4 specific contacts for a single Client event).

HELP ME! I've been messing with this for almost a week and, despite various calculations trying to trick FMP into doing it for me, I can't seem to come up with a solution!

Not sure to fully understand but I'd say you're missing some files

Make a Bookings.fp5 file, one record per booking

Add fields ClientID, to be used in a relationship to Clients by which you lookup client data, and a VendorID field, to be used in a relationship to Vendors by which you lookup vendor (property) data.

Using this relationship you can also build a relational value list showing vendor-related contacts

At this point you've two choices: add a ContactID field in Bookings, and make it a repeating field, or create a separate file ContactsPerBooking.fp5, and store there the contacts related to any booking