I have a table Applicants_MAS, column (STATUS) IN the report and drop down list in the form, i want to perform an action that when it will update and choose 2nd option after that option 1 will disable from selection and same for when update row with 3rd option(1st and 2ND option disable) and continue.
also (STATUS_ID_N ) is a column of numbering for sequence drop down list
how it will done ??