Conditional or dynamic value list?
Still new to FMP... Not sure if I'm looking for a conditional value list or a dynamic value list or maybe something completely different.
How can I create a dynamic dropdown list that shows numbers 1 to 133 and updates with each new record, not showing the numbers that were previously used.
User1 adds a new record. With this record User1 enters miscellaneous information and then selects number 5 from a dropdown list. Done.
User2 adds a new record. With this record User2 enters miscellaneous information and then selects number 4 or 6 since number 5 was previously selected by User1 it is not even available from the dropdown list.