Hi,
My objective is to have Next task button in each form with fields to enter, after clicking Next button, data will be saved and move to next page. So i came across this question in community and tried to follow it.
So i created a table with fields and at least an identity column and current_step (int domain) column. Made three self references. No fields are mandatory except identity column.
While running the creation, validation throws error message. How to properly define the self referenced table and make this scenario work? Please advice.
Process code group for table task
if @current_step=1begin update ce set ce.current_step=ce.current_step+1 from container_employee ce where ce.container_employee_id = @container_id and ce.current_step = @current_step select @execute_tab_task_container_employee_activate_detail_container_employee = 1endelse if @current_step = 2begin update ce set ce.current_step = ce.current_step+1 from container_employee ce where ce.container_employee_id = @container_id and ce.current_step = @current_step select @execute_tab_task_container_employee_activate_detail_container_employee_3 = 1end else if @current_step = 3begin update ce set ce.current_step = 100 from container_employee ce where ce.container_employee_id = @container_id and ce.current_step = @current_step select @execute_tab_task_container_employee_close_document_container_employee = 1end