Viewing Name and not stored ID

I have a form that opens up a record and views all the fields, selected via drop menus, from another form.

To save space, I don't store the actual responses, but rather the id number from the tables where the possible responses are stored.

I have 1 field, Reason, on the form, frmDiscipline. This field is from a table, tblReasons. The stored number is kept. How do I display the actual reason on the form frmDiscipline?

I don't know if this would make sense to anyone but me, but I will claify if necessary.

Thanks As Always,
RIP

Well, you can use the combo box wizard to do this.

It will stroe the id,but actually display the text from that other table.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn