First of all sorry for such a newbie question...
I have a table that contains 2 fields employee & id#. In my program (FileMaker13 pro advanced btw) I have a drop down to select Teacher Name. I wish to automatically fill in Teacher ID based on the Teacher Name selection.
My database has the following relationship;
Teacher Name = employee & Teacher ID = id#
All are defined as Text fields
thanks in advance,