Really BASIC question, sorry

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.
 
J

Jack Sheet

I think this addresses my problem (yet to try it out but it looks good).
Looks like a lot of other useful stuff there, thanks for the link.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top