My situation, briefly, is that I'm using Filemaker to manage an inventory of gear that I rent. I'd like to keep record of which gigs each piece of gear has been on (helps with troubleshooting). I'd like the Value Lists of Gigs to be alterable by script, but I'm not seeing an obvious way to do that.
For example, I'd like to (roughly):
click button -> run script -> prompt me for name of upcoming Gig -> Add that name to Value List for UpcomingGigs
then after the gear returns from the gig:
Click button -> Copy name to value list PastGigs; remove name from value list UpcomingGigs.
There are other details in the process that I can manage... But the crux of this topic is how to reference and alter the contents of a value list from within a script. Thoughts? Thanks,
Use a table and base the value list on that.