Hi!
I want to control the movement of incoming and outgoing tools in a certain warehouse.
In a table, I created the control fields;
txt_Data; txt_Hora; cbo_Tipo; cbo_Motivo; cbo_Responsavel; txt_Obs.
What I want is:
In the first record/row, the value in the 'cbo_Tipo' field should always be 'Entrada'.
In the following records, the value in this field must be different from the value entered in the same field of the previous record.
In other words, after an 'Saída' movement, only an 'Entrada' movement can occur, and vice-versa.
The ideal would be that the 'cbo_Tipo' control only shows for choice options, all the available items except the item chosen in the previous record.
In the example in the image, the user could only have the chance to choose the 'Entrada' option since the previous movement type was 'Saída'.
Thanks for any help.
JotaPA
I want to control the movement of incoming and outgoing tools in a certain warehouse.
In a table, I created the control fields;
txt_Data; txt_Hora; cbo_Tipo; cbo_Motivo; cbo_Responsavel; txt_Obs.
What I want is:
In the first record/row, the value in the 'cbo_Tipo' field should always be 'Entrada'.
In the following records, the value in this field must be different from the value entered in the same field of the previous record.
In other words, after an 'Saída' movement, only an 'Entrada' movement can occur, and vice-versa.
The ideal would be that the 'cbo_Tipo' control only shows for choice options, all the available items except the item chosen in the previous record.
In the example in the image, the user could only have the chance to choose the 'Entrada' option since the previous movement type was 'Saída'.
Thanks for any help.
JotaPA