I know this is very basic, but it escapes me.

Cursor one has a field with a FK that points to cursor 2.

A combobox has as controlsource the FK in cursor 1. Cursor 3 (derived from cursor 2) provides the rowsource of a combobox. I want the combobox to show a description, not an ID, and the dropdown to do same. Can this be done without RELATING cursor 1 to either cursor 2 or 3?

TIA,

Alex