1 Reply Latest reply on Jul 27, 2012 8:17 AM by philmodjunk

    Use external file as values for drop down list



      Use external file as values for drop down list


      I have a file called Projects. In this file, I have Part field for our parts that are used for that particular project / customer.

      I have another filed called Parts that consists of 3 fields; Part, Part Descrtion and Price. 


      I would like to create a drop down list of our parts for that Part field in the Projects file. However, I would like the values for this drop down list to come from the Parts file that is external and not related to the Project file.

      Can this be done? What is the easiest way to be able to pull data from the Parts filed into the Project file? 

      It looks like to do this, the files have to be related. But I do not want or know how I would relate these 2 files. Can anyone offer assistance?

      Any help here would be greatly  appreciated.
      I have FMPro Advanced 12 v2
      OS - Windows Vista on desktop, Windows 7 on laptop

        • 1. Re: Use external file as values for drop down list
          1. Open Manage | Database | Relationships.
          2. Click the far bottom left button to create a new table occurrence.
          3. Select "add FileMaker Data Source" from the Data Source Drop Down menu
          4. In the next dialog that appears, find and select your Parts file.
          5. Then select the parts table.
          6. Click OK until you have left Manage | Database
          7. Now open Manage | Value lists and you can set up a vale list to specify values from the table occurrence that you just added.