Here's another field puzzler

[habitude]

How to split an existing value list???

Let say, for example, you have a customer file and an employee file... & upon adding a new customer record, a user must select his employee name & number from very long ("emp" field)value list. All emp's work at the same location...

Same scenario, only now there are 2 or more locations and a handful of emps now work at

Loc A, another handful at Loc B, and so forth.

What I think I am searching for is a way to maybe select a certain "Key" field or radio button, or something that prompts a user to choose a Location, and presto, the proper list of emp's is presented.

Many thanks for the wisdom!!!

[Vaughan]

This is a relational or conditional value list. FMP will do it, but you have to have the value list data already entered into files.

For instance you'd have one file with locations. A related file has the employees related to the location records.