Add informtion to a record from another table
This should be very simple but don't know how to implement it in Filemaker 12.
I have two tables (Insignias, Associates)
Attributes for Insignias are (InsigniaNumber, InsigniaName, __kf_AssociateID)
Attributes for Associates are (__kp_AssociateID, AssociateName, AssociateInitials, AssociateEmail)
When I make a new record in Insignias I want to be able to choose from a list of Associate names. Other attributes from Associates table can be displayed with it. Nothing ever changes in the Associates table. I just want to be able to link an Associate with Insignias.