Setting up tables

[zaps via AccessMonster.com]

Hi Everyone,

I have created a form that uses a few combo boxes. One of the combo boxes
is to enter department. (marketing, finance, insurance etc) and comes from a
tbl_department containing ID# and Name of Department. eg. 1=Marketing,
2=Finance etc. The information from the combo box is saved in a main table.
Right now, in the main table the information is saved as the actual words -
marketing, finance etc. How can I set it up so that the corresponding
numbers are saved in the main table instead.

Hope that makes sense,

Thanks,
zaps

 

[Jeff Boyce]

Are you absolutely certain that the text is being stored? Is there any
chance the main table has that field defined as a "lookup" data type? If
so, it is storing one thing (the ID#), but displaying something else (the
text). This is one of the reasons you'll see a strong consensus against
using the lookup data type!


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/