I may be oversimplifying this, or maybe I don't fully understand your question. But....
If you set up relationships (either in the data environment or throught code) you can use whichever field you want from the CHILD or PARENT table as a controlsource for text boxes.
IMHO, surrogate keys are the only way to write relational database apps.
Marty
Marty Smith, CSQE