AnsweredAssumed Answered

Omit records when no related records

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

Title

Omit records when no related records

Post

 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.

Outcomes