Hi,
I have 2 DBs one has a list of locations the other a list of objects at those locations.
Location DB has a record LOC1 with attributes
Object DB has a list of of objects and locations they are at. The location is a relational field back to the Location DB
So the object DB has
LOC1 OBJ1
LOC1 OBJ2
LOC2 OBJ1
LOC2 OBJ3
What I want to do is have a form for the Location table with a button that displays the objects at that location. If I set that form and button up nothing happens when you press the button. It occurred to me that the relationship is on the Object table so I set the form up on the location table and it works. I.e. it jumps to the Location table selecting the appropriate record. So it works but exactly the opposite way to how I want it to.
Is my data set up incorrectly?