Setting invoice numbers
I am trying to set an invoice number for a table called "Architect Invoices" using a master table of "invoice numbers". However, on the find row below (see script), I get an empty found set which prevents me getting correct value for my invoice numbers in my table "Architect invoices".
Can anybody see why ? thanks