Global Fields with Dynamic Value Lists

[gman]

I have a customer contact database that I want to add new records and verify the record is unique. A partial list of defined fields are: Company Name; Plant Location; Customer First Name; Customer Last Name.

Normally the operator will go to a data entry layout and select field values from dynamic value lists. In the

[BobWeaver]

I can't think of any reason why you can't do this unless I'm missing something. As long as the global field is on the left side of the relationship definition, I think it should work. The fields on the right side of the relationship must be indexed, so you can't have globals or unstored calculation fields there. As long as you meet these conditions you should be able to use dynamic (aka related) value lists.

[John Caballero]

I just did a quick mock up. It works fine with either a indexed or non-indexed (global) field in the main file. Have a look at the attached files.

John_Sample2.zip