Auto populate related tables?

[dulux]

Hi all,

I'm kinda new to this but been around programming and filemaker for a while now.

I would like to be able to create 18 records with similar core information in one table from a related table and I'm not sure how to do this.

Basically I am registering a learner on a programme and there are 18 separate units on the course. I want one record per unit in my Modules table to reflect this, which is linked to the learner information table. When i have added a new learner to this table I want to be able to hit a button and have the 18 records - 1 for each unit, created in the Modules table and ready for recording their progress through the course.

Does that make sense? Hope you can help guide me here....

many thanks

Rich

[elo]

Assuming I understand this correctly, you have a table like Students and another table StudentModulesTaken.

When a student is created, you want to create 18 StudentModulesTaken records?

I cannot think of anything short of a button that invokes "Perform Script" on a custom script to do this.

The basic flow of the script would be to get the "primary key" or ID field for the StudentTable, then go to a layout for the StudentModulesTaken table, and start creating 18 records with the necessary items. There may be some fancy shortcuts, but at the end of the day, that's what you are going to be doing.

[dulux]

Hi there,

Yes, you have it absolutely right - that is exactly what I am trying to do. I have the basic process in mind, and I was hoping for some guidance in clever scripting jiggery-pokery with some kind of looping structure.

Thanks for your advice and time.

R