I am a newbie at FM but have dealt with some hardcore relational db in the past.

So it is with some embarishment I have to ask the following.

I am correcting someone elses work at the mo, and have come up against a small wall.

The item concered is a "pre invoicing system" that is to say you do stuff in filemaker it prints an invoice, export to the accounting package where all the real work happens.

The account package will auto gen its own invoice numbers, but I need to be able to store the last used invoice number in its own table.

The idea is that the filemaker "module" querries this table for the last used number, add 1, records this against the transaction and the last used number table.

whats the best way to do this, as each time i have tried a set field/getnthrecord combo script I get either blank in the field or ?

BTW the tables are not related.

Any help would be fantasic.

Kind regards.

Mark.

Hi Mark,

Have a look at the Execute SQL script step. It just may be what you need.

HTH

Tim