Passing ID number instead of Description

  • Thread starter Thread starter khinester
  • Start date Start date
K

khinester

Hello,
I have two tables, Address and Region

The Address table has a FK_RegionID.

Now how do I make the form for the Address, so that I
have a list box that lists the RegionDescription and NOT
the RegionID. BUT only store the RegionID in the Address
table?

Thanks
 
khinester said:
Hello,
I have two tables, Address and Region

The Address table has a FK_RegionID.

Now how do I make the form for the Address, so that I
have a list box that lists the RegionDescription and NOT
the RegionID. BUT only store the RegionID in the Address
table?
Click to expand...

User a ComboBox with two columns using the fields from the Region table as the
RowSource. Make the ID column zero width and the bound column. The Combo will then
store the ID but display the Description. The wizard for the Combo can do all of
this for you.
 
Back
Top