Hi all,
I am using the 12c Oracle Database and the 20.1 Oracle apex version.
I developed a Master child record transaction screen. I used an interactive grid for entering the child records.
For example My form fields
Master form
Document number ( primary Key like 1,2,3,4,5)
Type
Employee Name
Area
Created By
Created Date
.... etc.
Once created the master record user can enter the child record below
Document number (automatically assigned to the field)
Seq Number ( When the user clicks the add row it need to be generated automatically based on a document like 1,2,3) Like document no. 1 and seq no. 1 ,2,3
Product description,
Supplier
Qty
Created by
Created Date
etc
When the user deletes the in between the rows then we need to regenerate the rows is it possible to do it?