How to: Auto-fill fields or Create New Records

[Sean L.]

Howdy,

I've got two files, one with employee names, the other with training session summaries.

The training sessions always have two employee trainers and two employee students. Currently we enter the four names manually in each new training session record. I would like to be able to type in the last name of the first employee and have a pull down menu to select valid employee first names from. If the last name returns no first names, or if none of the first names match I would like to type in the new first name and have a new record created in the employee file to match. Then the same would be repeated for each of the three remaining employees. Info about the training session is then added to other fields.

Any suggestions would be much appreciated. Thanks!!

Sean

[BobWeaver]

You can use value lists to display names from the employee file. If there are too many employees for that to be practical, see the topic: "FM newbie / needs lookup/relationship help" in the FileMaker Pro 5 forum.