Is there a way to create a menu of codes and code definitions next to each other in a menu that will allow the user to select the code without getting the definition as well? I am presently putting the code on one line and the definition on the line below it, This is clumsy. Access has this option. Any ideas?

Thanks.

This feature is built-in to FM. If you create a value list, you are given the option to "use values from a field". This field can come from another file used to store Codes and Definitions. With the "value from a field" option you can select two fields to be displayed. The first would be Code and the second Definition. Only the first field value is actually entered into the field given the value list. The second is used to aid in the selection. This should all be covered in you FileMaker manual. -bd

quote:

---

Originally posted by rmsherman:

Is there a way to create a menu of codes and code definitions next to each other in a menu that will allow the user to select the code without getting the definition as well? I am presently putting the code on one line and the definition on the line below it, This is clumsy. Access has this option. Any ideas?

Thanks.

---

Also you can use relations e.g. in our solution in value list is value for field 1 and fields 2, 3, 4 and 5 are automatically populated by values from related file.