Listing Missing Entries in Related Table

[nutthick]

I thought I was getting the hand of scripting, but my brain has stopped on this one.

I have two related tables, quotes and invoices. When a quote is sent out a PO number is received and the invoice generated on that PO number (same as everyone else). However, because of the strange way my industry works, the job can completed before any paperwork has started, meaning I only have a record of the date the quote was sent (held in the quotes table), but nothing in the invoices table.

What I'm trying to do is created a list of all quotes that have been sent (i.e. will have an entry in Quotes::Date_Sent), but no related entry in the invoices table. I'm totally stuck on even how to start this one. Any help would be really appreciated.

Thanks

[Wim Decorte]

You could have a calc in the quotes table that counts the # or related records in the invoice table. Do a find on those records in quotes where that number is 0 and Date_sent is not empty.

[nutthick]

Thanks Wim, I get the idea, although I need a little more help. I presume I should use the Count function in a calculation field, but how do I get the field to count the related records?