Drop Down List values should not be repeated once selected for the particular date

Hi,
I have a table Allocation where one user fills 5 fields of the form & the other 2 columns are to be filled by another user. This value must be auto-populated as Drop-Down List based on the value selected by the first user.
How shall I achieve this?

0 2 466
2 REPLIES 2

Steve
Platinum 4
Platinum 4



Thank you Steve.
Appreciate your help.
I have used Slices to achieve this & itโ€™s completed!!

Now, I would like to have a validation done where,

On a given date, the Vehicle allocated for the particular time slot, should not be shown in the drop down list or the entry should not be allowed.

Pls help. It would be of great help.

Thank you.

Top Labels in this Space