Show a list of records that the two fields are matched

Hi there,
I actually need a MS Access database alternative. I came across Knack. I have been playing with it for a few days.
 
I understand that I can make connection between records within two different objects. However it has to be done individually and manually.
 
However, is there a way that I can link a field in an object to another field in another object automatically as I only want to show a list of records that the two fields are matched.
 
Cheers

It's a pretty good replacement for Access in many many ways - a lot of us here are former Access users!

I am not quite getting the concept of your post though - can you explain what you are trying to do?

Julian