I couple of questions to clarify what you want:
1) The entries for Customer::state are for example CA, NY, correct?
2) For the selection list, did you make the field state:state name a drop down or pop up menu using a value list?
3) You want a layout with customer information where the user can choose from a menu the state (California, New York etc), correct?
Thanks for your reply. Here are the answers for the questions you have asked for:
1. Yes. That's correct.
2. The field customers::state is a dropdown and should show the states::statenames.
3. That's correct too. The Problem is, that I have in the customers table "only" the field with the codes (customers::state), but user should allways see the statenames.
Kind regards, Daniel
You can set up a value list where column 1 is your code and column 2 is your state name. You can then hide column 1. If you format your field as a pop-up menu, column 2 data will show in the field even though the code is the value being stored in it.
Cool... The Menu instead of List was the solution!!! I have allways tried to use the list and didn't realized, that these two behave so differently regarding to that point.
Thanks a lot to all who helped me out!
There is a way to "fake" a list format into this appearance.
Format your list field to show the arrow control.
Resize your field width so that only the arrow shows.
Place a related field or calculation field that shows the name next to the arrow so it looks like one field.
Use a script trigger or format this added field as a button to use Go to field to enter the original ID field.
It's not perfect nor near as nice as a Microsoft Access type combo box, but it might do the job.