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.