Hi, thanks for that. I did actually get a response today from PCSOFT, so for anyone interested:
At the end of your INSERT statement you add the SELECT statement shown.
INSERT INTO tbl (auto,text) VALUES (NULL,'text');
SELECT LAST_INSERT_ID ();
Cheers
Reg