J
Jack Sheet
I have a database containing just 2 simple tables:
T_Main
Fields are:
MainID (Autonumber, primary key)
MainField (text)
LookupField (text)
T_LookUp
Fields are:
LookupField (text, primary key)
LookupRate (currency)
There is a one(T_Lookup) to many(T_Main) relationship based on LookupField
with enforced referencial integrity.
I have a form for updating T_Main.
This contains a combobox for selecting LookupField from a dropdown menu and
entering the corresponding value in the field of that name in T_Main.
Problem:
I want the form also to display the corresponding LookupRate based on the
selected value of LookupField. This should be non-editable on the form, but
just displayed for information purposes. I can see the rate in the dropdown
list in the combo box, but having selected the entry only the key field is
displayed.
Thanks for your help. Sorry for such a pathetic question.
T_Main
Fields are:
MainID (Autonumber, primary key)
MainField (text)
LookupField (text)
T_LookUp
Fields are:
LookupField (text, primary key)
LookupRate (currency)
There is a one(T_Lookup) to many(T_Main) relationship based on LookupField
with enforced referencial integrity.
I have a form for updating T_Main.
This contains a combobox for selecting LookupField from a dropdown menu and
entering the corresponding value in the field of that name in T_Main.
Problem:
I want the form also to display the corresponding LookupRate based on the
selected value of LookupField. This should be non-editable on the form, but
just displayed for information purposes. I can see the rate in the dropdown
list in the combo box, but having selected the entry only the key field is
displayed.
Thanks for your help. Sorry for such a pathetic question.