2 Replies Latest reply on Mar 15, 2017 6:02 PM by vickie.w

    Using a calculated field to create values for Value List




      FileMaker newbie here.


      I have two tables, not related, one is a contact type table and I have created a calculation putting the First Name and Last Name together so I can have both names in the new field. I then have a field in another table that I want the information from the calculated field to display in as a Value List - drop down, so you can chose the correct person.


      I have the two fields, the calculation etc all set up, but when I click on the drop down arrow all I get is a "?". Have I missed something along the way? Can you not use a calculated field in this way?


      Thanks in advance for all help and suggestions.