I want to use combo box to select the resources to assign, but want to only show the remaining item, each time I click for new record.
for example staff allocated for different jobs.
seat assigned to each person, so each time the free seats only be displayed in the list, Not the already assigned.