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?