DUMB QUESTION -- How do you create a pop-up list (drop down list) based on a field name, so that when the particular value is selected, the record advances to display all values in the selected record?

To do this, do you need to create a second layout or create another file (table) that contains the records you wish to display?

And if the record is not displayed, I want the suer to be able to create a new record.

If so, please explain???

TIA

I'm afraid I don't understand what you're trying to do. Display all what values in the selected record? All the fields? Are they not on the layout with the menu?

Please give us some more information. You might be on the right track with the second layout solution, but I'm not sure. Is this a search of some sort?

Chuck

Chuck thanks for your reply.

I am trying to create a pick list on the indexed field Customers. When a user selects a particular customer, then all remaining fields in that file for that customer are now displayed.

It would be similar to advancing to the next record, only it would be advancing to the record selected from the drop down pick list. I hope I'm making myself clear.

It's probably something very simple I'm not seeing. In other products (e.g. Access, Oracle, Alpha V, etc...), one simply defines the field as a drop down pick list and when the user highlights the particular customer he/she wants, they hit the enter (Return) key and that record is displayed.

Thank you.

I think I understand. Let me restate it to make sure.

The user is brought to a layout with blank fields on it and one field that is a menu where they can select which record they wish to view. Once they select from the menu, the blank fields fill in with information from the selected record, correct?

If this is correct, make the field the user selects from a global field. Create a self-join relationship between the global field and the field that the menu gets its list from. Display fields on the layout that are actually related fields through this relationship.

Chuck

Okay, now I;m going to be a real PITA (pain in the a..), but could you send me an example. I think I understand how and why you are using globals, but an example might paint the picture better for me. Thank you.

Sounds like maybe you just want to see a list of customers. Make a list layout for this. Put a button on the layout that takes you to another layout that shows the customer details.