Form entering ID number into table rather than data

[joel10000]

I am new to Access, and I have a database where I have forms wit
comboboxes which enter text data into the tables. The columns of th
tables are receiving ID numbers, from the form comboboxes, rather tha
the text data. How do I change this so that the tables contain the tex
rather than the ID numbers from these table lookups. I am using tabl
lookup with the form comboboxes. I also used the form wizard to creat
these forms.

Thanks for your help!!

joel1000

 

[Rick Brandt]

I am new to Access, and I have a database where I have forms with
comboboxes which enter text data into the tables. The columns of the
tables are receiving ID numbers, from the form comboboxes, rather than
the text data. How do I change this so that the tables contain the text
rather than the ID numbers from these table lookups. I am using table
lookup with the form comboboxes. I also used the form wizard to create
these forms.

You would change the bound column of the ComboBox, BUT...a properly
designed database structure would work exactly as yours does now. What is
the purpose of the ID numbers in the other tables if that is not what you
are going to store?

Classic Sales Order example:

I have a table of Orders and each entry needs to identify the Customer for
the Order.

I have a CustomerMaster table where all data concerning customers is stored
and each customer record is assigned an ID value.

When creating an Order record I want to store the CustomerID value, not the
customer's name (which might change or might not be unique). If I want to
*see* the Customer's name (or any other customer data) on my Orders form I
do so by retrieving them from the CustomerMaster table with some sort of
Lookup mechanism that uses the CustomerID as its key.

Don't concern yourself with trying to make the table easy to "look at".
That is not what tables are about.