Simple Layout question
I've been failing at using FileMaker today. I think the answer to this question is incredibly simple but I cannot solve it.
I have three tables, Sales Order, Salesperson and Products. Salesperson and Products are linked to Sales Order. The relationships are set to not create new entries between the tables.
On the Sales Order form, can i not display the relevant data from other tables? For example, in the Sales Order layout, I have a pull down menu to select the salesperson and a field that displays the salesperon birthday from the 'Salesperson' table. Upon selecting a salesperson from the pulldown menu, shouldn't I be able to see the birthday of the salesperson in that field?
What am I missing?