Hello RVK
Thanks for that, it's appreciated. But also my apologies as my example was flawed. I used what I thought was a similar comparison, but it wasn't. I thought my actual project might invite ridicule, but there's no alternative.
It's a database for an on-bus ticket machine.
It has a combo box which displays where the bus is at the moment. A grid below it (one column) to list all the possible places on the route (both of these reference a single list of locations, but use different queries/ datasets) and then there's the fares table to be searched. Basically in English I am trying to put "Search the fares table where departure = the combo box, destination = the grid and then display the fares available.
Apologies, I should have been more forthcoming to start with, but previously when I mentioned this project I ended up spending half the time explaining why I was doing it (a different forum, to be fair).
So I can't see any way to link the two together.
Any ideas, please?
Derek