billblitz

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,

Bill

Outcomes