rgates@ttcdas.com How do you test the existence of a child BO within a query in the WHERE section? I have tried to see if the BO.ID ='' or BO.ID = NULL but neither return results. My current setup is a 1-to-1.
tford Use EXISTS or COUNT ... something like: FIND Account WHERE COUNT Transaction WHERE(Transaction IN Account.Transactions) = 0
rgates@ttcdas.com I didn't know you could do something like that. I have always just used the Simple Form tab to create queries. Do you notice that if you switch between Simple Form and Rule Form that the code you type in gets destroyed even after you save and then toggle?