I have two fields that have a one-to-one relationship. One is a code, the other is the name associated with the code. I want to set something up that is a List Box for two fields. Users should be able to search in either one. I also want to see all values even when there's a selection, in the grayed out way you see it in a list box.
Since you have a one to one relationship could you join the two tables together then create a composite field with the code and name? You can then create a List Box using this new field. The search functionality will work as well as the color schemes for selected, possible and excluded.
Here's something easy to try - it will take you two minutes to see if this might work as a solution. In your document, create a new List Box. In the place where you would choose a field scroll down and click on Expression. Now, what are the names of the two fields you want? Imagine that the fields are named fldcode and fldname. Type this as an expression fldcode & '.' & fldname click on OK. Now you have a listbox showing the pairs of field values. Click on any of them just like a normal List Box and it will select a value in both fields. You can search values just by typing the thing you want to search for just like a normal List Box. You can define the same kind of thing in a multibox. Good Luck!
