use a combo box control in your form. use the following property settings
for the combo box, as
ControlSource: TenderNo
RowSourceType: Table/Query
RowSource: T_Tender
ColumnCount: 2
ColumnWidths: 0"; 1"
BoundColumn: 1
ListWidth: 1.25"
adjust the *second* number in the ColumnWidths, and adjust the ListWidth, as
needed, so that the full TenderName values show in the droplist.
recommend you read up on combo box controls, and their properties, in Access
Help, so you'll understand how they work.
hth
<sa*************@yahoo.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Imagine two tables. One is T_Tender, other T_Material
T_Tender fiels: TenderNo, TenderName
T_Material fields: MatrNo, TenderNo
There is relation across TenderNo between two tables. I would like to
simply show TenderName in the table T_Material, rather than TenderNo.
But access should use TenderNo for that entry.
I am finishing now. My target actually to enable the user to edit
TenderNo for T_Material table using a form. Instead of TenderNo,
TenderName should be visible there to make the user job easier.
Will be appreceated for any help.