Hi,
Is it possible for a select field to display only those options that have not been picked yet?
The database I'm working on is for booking time. In the field for 'Date', I specify all the available dates ('3/1,3/2,3/10,3/17', etc). User 1 selects date '3/1'. The next user would see only '3/1,3/2,3/10,3/17', that is, choice '3/1' would have been deleted. This would prevent two people booking the same date. Thanks
cheers
Is it possible for a select field to display only those options that have not been picked yet?
The database I'm working on is for booking time. In the field for 'Date', I specify all the available dates ('3/1,3/2,3/10,3/17', etc). User 1 selects date '3/1'. The next user would see only '3/1,3/2,3/10,3/17', that is, choice '3/1' would have been deleted. This would prevent two people booking the same date. Thanks
cheers
select field display only options not picked?