I will have a list of owners, each with their own unique OwnerID.
However, to make it easy on myself, I want the owner names to be on the combo box list, but have the form enter the matching owner ID into the database rather than the owner name.
Is this possible? I assume it is, since Access seems quite flexible. So far, however, I haven't found any mechanism that will allow this. Do you guys know of any?