AnsweredAssumed Answered

Calculated Field or Automatic Entry?  Not sure of the terminology?

Question asked by cheathamtech on Nov 22, 2009
Latest reply on Nov 22, 2009 by Sorbsbuster

Title

Calculated Field or Automatic Entry?  Not sure of the terminology?

Post

To paint the picture:

 

Imagine 5 technicians who each serve 3 locations.

Each tech has a Key...001...005.

In the tech table, I have his/her name, address, e-mail, etc.

I have a key set in another request table layout, so that when a person enters 001 in the key tech field, all 001's info shows up on the form..  That's great and a real time saver...

 

BUT...

It would be even better if when the person requesting service entered one of the 15 locations, Filemaker already knew which tech was assigned to that location and filled it in automatically...

 

Is there a way to set a field to check the location data and enter the correct info automatically, OR do I need to set that field as a calculation?  (which means all the tech IDs must be converted to numbers??)

 

I know this must be possible, just a little lost on how to do it...

 

Thanks! 

Outcomes