AnsweredAssumed Answered

Use Find Or Relationship?

Question asked by kbsaunders on Feb 25, 2012
Latest reply on Mar 16, 2012 by kbsaunders

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.

 

Thanks,

 

Kevin

Outcomes