AnsweredAssumed Answered

Omit records when no related records

Question asked by ShariFoucher on Feb 17, 2012
Latest reply on Feb 17, 2012 by philmodjunk


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.