Script to create new records using table?
I am trying to write a script to create new records quickly. I have a table which is a list of horses names. I have given them each an ID number too. Then in another table which is their daily work record, I want to create one new record per horse name, with a chosen date.
I have a very basic understandiong of scripts, I can create the new record and go to the date field, but then I want to pause and enter a date, then resume and go to the horse name field and then select the first horse name from the horse name table, then repeat all the steps with the same date, but select the second horses name, etc,etc. Until reaching the last horse name record.
I hope this makes sense and someone can help!