Viewing Name and not stored ID

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top