Newbie needs help with table

[Jacques Schett]

I have created a database with two tables:
Product
Orders

The product table contains the following fields:
ProdID
Descr
OnHand

the orders table contains:
CustID
ProdID
QTYOrdered
Cost


When I created the Orders table I wanted to use the ProdID on the
Product table as a lookup field. When I created the lookup type I
selected from the Product Table the ProdID and Descr.

When I try to do data entry the system does not properly input the
data into the orders ProdID table.

What I want is to display the ID AND the Description but I only want
the ID placed in the orders table.

How can I do this?

-JS-

 

[jahoobob via AccessMonster.com]

First things first. You should do your data entry via a form and not in the
table as it appears you are doing.
Secondly, what do you mean "does not properly input the data." This could
mean a number of things. One being that it puts the Desc in the ProdID.
Check your bound column in your combobox properties to make sure that the
ProdID column is the one that is bound.