Selection in one field determining the selection of another...

[SilverFang]

The Room Price field, now that it's finally showing the correct prices. But when I open the combo box for the Room Number field, it displays all the columns in the dropdown box, even for the prices.



I don't mind it showing the room type (Family, Double, etc) but I don't like the combo box showing the prices as well, especially the multiple prices.



Can I set it to show only the first two columns in the dropdown list, but still be able to display the correct price in the Room Price box further below?

[isladogs]

I haven't read the rest of this thread in detail.

You have five fields in the combo.
Either set the widths of the last three fields to zero or if the last three aren't needed here just have two columns in the combo