Is it possible using a form to use lookup tables to add raw data to a table.
I have been able to add data to a table, but the lookup value is being
stored in the table.
If this is possible, what steps do I need to take to set it up?
Thanks,
Scott
You seem to be yet another victim of Microsoft's misdesigned,
misleading, and all but useless so-called "Lookup Wizard".
A Lookup table is just a table. Having a combo box in your Table
simply conceals the actual content of your table (the linking field,
usually a number) from view. It *APPEARS* to have the looked-up value
in the table, but it doesn't!
Your table should contain the numeric ID; it's very easy to put a
Combo Box control on your form to do this. The Form toolbox combo
wizard will walk you through the process; basically, the combo should
use the lookup table as its Row Source, the ID as its bound column,
and the readable "looked up" value as its first visible column. It is
not necessary to have the field in the table defined as a Lookup field
in order to do this.
