auto completing a second field based on the first field input

Discussion created by billblitz on Mar 10, 2014
Latest reply on Mar 11, 2014 by keywords

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,