2 Replies Latest reply on Jul 6, 2017 2:40 PM by philmodjunk

    Conditional Value List not working on PC


      I have setup a conditional value list for golf club shaft descriptions depending on whether you chose graphite or steel as the type.  I have a table 'Shaft Values' with type and description as the two fields and each type has four records with different descriptions.  I set the type drop-down list based on the field type in the table 'Shaft Values'.  I then created a relationship to the table I will be storing the data in (Fitting) and the 'Shaft Values' table linking the shaft type in the 'Fitting' table to the field type in the copy of the 'Shared values' table created by the relationship request.  The value list for the description is based on the field description in the related copy of 'Shaft Values' while specifing it only contains items from the related table 'Fitting'. This works perfectly on a Mac but doesn't work on a PC.  When I load the layout based in the 'Fitting' table the drop-down list does not appear for shaft type.  I have checked the Value list definitions, the field specifications, and the table relationships on the PC and they are the same as the Mac.  Help!!

        • 1. Re: Conditional Value List not working on PC

          It's hard to figure this out just from reading, without a file.  This doesn't help, but it's probably something very simple, like pointing to the wrong relationship.

          Something about this doesn't sound right:

          in the copy of the 'Shared values' table created by the relationship request.

          What happens if you just take the exact file that works on the Mac (put it on a thumb drive), stick the thumb drive into the PC and open it up on the PC?

          I'm assuming same exact version of FileMaker on both computers.

          Also are you using the same account, with the same privileges?

          • 2. Re: Conditional Value List not working on PC

            What you describe should work and identically in both systems.


            When debugging relationship based conditional value lists, it's often helpful to temporarily put a portal to the value list's table occurrence on your layout. If the relationship is working, your portal should be able to list the same values as your conditional value list and that can tell you to take another look at your value list setup. If it does not list the expected rows, then you know that something is wrong either with the relationship or the match field values of either the layout's current record or the related records in the other table.