Omit records when no related records
I have two tables - dog registration and dog license, linked by dog id. There are records in the dog registration table that do not have related dog license info.
I need to print letters to send to owners to remind them to reregister. I am doing a find on layout entry script that looks for deactivate = No in the dog registration table. I also need to eliminate records from printing when there is no related dog license info. I've tried several things, but can't seem to get the mechanics to work.