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.