Looking up a lookup

[markmarko]

Hello,

It so happens that I have fields that lookup a field in another table. One
or more of the columns I want to display when the user uses the combo box is
itself a lookup. The higher level lookup only displays the key from the low
level lookup.

Err, here's an example.
Table A lists regions we work in, with other region related data.
Table B lists Sales products that are available in each region (the region
field looks up Table A)
Table C lists package deals, so it looks up Table B, and I want to include
the listed region, so the user can be sure it's the right deal for the sale.

So instead of showing the name of the region in the Table C lookup, it shows
the value that's stored in Table B, not it's lookup.

Is there a way to get the lookup in Table C to show the region word (instead
of key number?)

Thanks!

 

[Ken Snell \(MVP\)]

Yes, by changing the Row Source query to include the Table C and join it to
Table B, then include the desired field from Table C in your query's output
fields.

 

[markmarko]

I wonder if you might be able to clarify "Row Source query". I'm not sure
what that means.

Thank you.

 

[markmarko]

Let me rephrase that....

Which Tables lookup Row Source should I alter? Table B's? Table C's?

 

[markmarko]

Ok, I've got it working. It was the lookup in Table C that needed it's Row
Source Query to include Table A.

Thank you very much!

 

[Ken Snell \(MVP\)]

I'm glad that you found the answer. I've been away and couldn't post any
replies.