I have a small DB which I host via IWP with Server 12 Advanced.
I have 50 users via IWP, all of which select from a pick list containing 32 options
What I need assistance / guidance with is that after each user makes a pick from the list, then the next time they create a new record and use this same PICK list, I want the pick list to be modified by eliminating the choice they made previously, thus reducing that specific users options in the pick list by the option they chose previously, and going forward, reducing the pick list for that user each time they make a choice. This action applies to all users, reducing their individual pick list choices each time they've made a choice from the pick list.
So users could have more choices than others depending on how many times they've made a choice from the pick list.
Hope this is clear. I'm using Windows 7.