inherit values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jkanters - 04 Dec 2007 16:18 GMT

In my table2 I have a field called field2 which is a combo box. The values
are found in table1 in field10.

Then I want in my form to show field9 from table1 corresponding to the value
in field10.

How do I manage that?

Reply to this Message

JEA - 04 Dec 2007 17:22 GMT

Sounds like you need to look up normalisation.
What happens if you want to add another value to the combo box? You're going
to have to add a whole new record to table1.

Anyway, a DLookup would work. On the form you want to display this create a
text box. In that box type:

=DLookup("[field9]", "table1", "[field10] = [comboBox]")

comboBox is on the same form in this example.

I strongly suggest you read up on normalisation, you may get loads of
problems later if you don't.

>In my table2 I have a field called field2 which is a combo box. The values
>are found in table1 in field10.
[quoted text clipped - 3 lines]
>
>How do I manage that?

Reply to this Message