Hey all,
I'm trying to get a combo box to display one value (Race) on a form but display another value (RaceID) in the underlying table, with both Race and RaceID tied to the combo box. This is the setup for the part of the database I'm working on:
Table 1 = tblPtMain - This table has general demographic info about patients, including the field Race. I used the LookUp Wizard (Combo Box) to select the RaceID and Race from tblLstRace.
Table 2 = tblLstRace - This table has two fields - RaceID and Race.
Form 1 = frmPtMain - This is a data entry form where users will enter the demographic info including Race, via a Combo Box.
I would like the FORM to display the Race field as the actual race, but the TABLE to display the race field as the ID. I've tried changing the "Row Source" order and the "Bound Column" in both properties but I end up saving the actual race in both the form and the table. See images below.
Attached images are:
1 - Race Field properties from the table tblPtMain.
2 - Partial form view with combo box from the form frmPtMain.
3 - Race field properties from the form frmPtMain
I have several other fields that I'm trying to do the same thing with. I've gotten most of them to work the way I want, but after much trial and error and no straight-forward method to the madness. It seems like it shouldn't be too hard, and I was hoping you may have a simple solution that I could do most every time that would work.
Thanks!
Jon