basic scripting...series of new records including constant field contents
I'm trying to piece together an inventory program that will let me track parts from items that are being disassembled. Ideally I would like to set up a script to create a series of records, accept input for the constant fields, and automatically assign a value to the non-constant field for each record. The constant fields include the disassembly date, the item being disassembled, and the person doing the work. The non-constant field would contain descriptions like "AAA battery", "transistor", "capacitor", etc. etc.
Would anyone have an example of something like this, or help me frame the problem in a way that makes more sense?