I hope this hasn't been answered 100 times, but I haven't been able to find a relevant post.

I have 2 simple related files: Ticket Holders and Tickets. Ticket Holders has personal information about people who bought tickets to an event. Tickets has information about the tickets: seat numbers, etc.

I'm trying to use a value list in Ticket Holders to assign tickets to people. I have a repeating field setup to hold the ticket id's and have assigned a value list to the field.

However, I can't figure out how to have a ticket removed from the list once it's assigned to a person.

I've tried a huge number of things: calculations, script, tips and tricks from depleting inventory and the used/unused value list example found in this forum.

I can't figure out how to "mark" a ticket as "used" once it's been assigned. I easily created a calc. field in the Tickets DB that showed a one or a zero for assigned vs. not assigned - however it's based on an if statement using a related field - thus the calc. field can't be used for a relationship itself.

If anyone can point me in the right direction, I would greatly appreciate it. I've been wrestling with this for over a week and am getting desperate.

THANK YOU!

David

Hello,

The best way would be to index your unstore calc!!!

Check the Article section for this very well covered feature.