Main TableName::MemberField to MemberTable::MemberField // peferable unique number field in members table
Phone_Number field is defined as lookup using the the above relationship name and choose the member telephone number
When you enter a member number in the Main table member field the telephone number auto enters.
I'm not sure if that is the answer or I am not familiar with your explanation. I am using the GUI page of relationships. I have not had to type any definition lines. I have a large flat DB (one table) with over thirty fields. The members are engineers names (last, first (employee id)). There is no way I can have a duplicate name problem, thus no numbering system used. A FileMaker rep. showed me how this is done over two years ago, but I have lost my notes and the memory is not as good as it used to be.
I do remember that he needed to create a table or another DB of just the engineers and their phone numbers in order to accomplish the relationship. I remember him doing it in less than two minutes. I have changed laptops and suspect it got lost in the transfer.
as stated above... in relationships you create an occurrence of the table and join it on name field... it is a pointer to the same table, not duplicate table and data.
the join on name can be used to auto-enter the phone number in a phone number field, from the second occurrence
also referred to as a self-join...