Adding fields in indiviudal record using a script

[MikeForest]

I have a file where i have a field named "Actors total" The idea is that the user enters a number here that signifies how many actors are in a screenplay and then hits a button that is labeled "update." The script will then insert as many fields in the record as there are actors. These fields will all have pop-up menus from a value list.

How do I do this?

I need to be able to do this individually for each record since the number of actors will vary and I do not want extra fields floating around.

[Fitch]

You could use a related file for actors, with a script that creates new records. Display the records in a portal and that comes pretty close to what you describe.

[MikeForest]

Thanks, I will give that a try

[MikeForest]

Alright, I dont think that is working or I am doing it all wrong...

[Fitch]

I've attached a little example file, it's bare bones but you should get the idea.