Skip to Content
0
Former Member
Oct 13, 2005 at 04:40 PM

Retrieve last ID inserted

159 Views

Hi,

I've a custom form within some EDIT fields and a Matrix binded to two user tables using a UDO.

I use it to handle Master-Detail data.

Adding a new record I would like to retrieve the last id inserted in Master table and then add the new record with ID = LastId + 1

How can I do this? May be I need to use an event which is raised just before the record is added to database and here execute my SQL statement which retrieve the last id fro Master table?

I hope it's clear.