1 Reply Latest reply on Aug 3, 2009 4:59 AM by mrvodka

    relationship gathering data problem.



      relationship gathering data problem.


      Hi, i'm very new to filemaker and i'm trying to create fields that automatically pull data from another table.

      I have created a parent/child relationship between the two tables and i have fields on the layouts with the unique serial numbers, and i am able to pull fields data from another table, but it seems im doing this using the uniqueID's of the record.

       But what i want to do is  pull field data from another table by matching name.
      So say for example a large list of company names. The user would type in the company name (ideally drop down menu) and not the ID and it would pull the data.

      Is this possible, if so how?