AnsweredAssumed Answered

Find Requests for Relational tables

Question asked by WilliamSouth on Aug 29, 2014
Latest reply on Aug 29, 2014 by philmodjunk

Title

Find Requests for Relational tables

Post

     I'm trying to set a find request that differentiates from my clients that purchased and ones that have just register.

     Example Tables

     Registration------>Customer--------->Invoice

     What kind of find can I make 

     Registration:Consultant=="DEBORAH" and IsEmpty(Invoice:Invoice_ID) or isEmpty(Customer:Cust_ID)

      

     I know I can make a field That has the value "purchased" or "not purchase" but would like to stay away from that,  for other certain reasons but will if there no other solutions.

     Any help would be great thanks

Outcomes