Hi

How do I get filemaker to check if an invoice has been previously printed?

I’d like to add a custom message to my printing script.

The message would read something like “This invoice has been printed previously, do you wish to print it again”

I’m not sure if this question should be here or in the “calculation forum”

Thanks for the help.

Without knowing your structure it is hard to be specific but one approach would be to store (if not already stored somewhere) the invoice number for all invoices as they are printed.

In your invoice routine you could then do a find on that number and if it already exists (found count>0) give the appropriate message

hth

Phil

I'd make a "Date Printed" date (or timestamp) field in the invoice table. Your printing script would include something like this:

If( IsEmpty(Date Printed) )

     Set Field( Date Printed ; Get(CurrentDate) )

 Else

     Show Custom Dialog( "This invoice has been printed previously on" & GetAsText(Date Printed) & ". Do you wish to print it again ")

etc.

Thank you both for your time and the appropriate advice.

Much appreciated!