I am trying to set up a layout that will display owners who's property is in a selected zip code. The owners don't live in the property. In other words, their address is different than the property's. Once found, I want to print mailing labels using the owner's address, not the property's.
I would like to do this using a relationship but can't figure it out. I am selecting the zip codes via a self-join relationship but can't figure out how to have a found set of owners who's property is in that zip code. Is this possible or do I have to use finds instead?
If possible, how would I set it up? If not, how would I set up the finds? What table would the layout be based on?
I am in over my head on this one and would appreciate any help.