create record in different table
The best way to pose the question is to fully describe what I want to do. I have an application that documents board meetings for an association. The base table for the layout is "Meetings". There is a related table named "Attendance" and another related table named "Trustees". On the layout is a portal to the Attendance table with Trustees Names and a checkbox to indicate if they are present or not. What I want to do is when they create a record in Meetings for a new meeting, I want to populate the Attendance table with records for each Trustee for the current meeting. Then all they must do is, for each trustee, indicate if they are present or not.
So how do I read each record in the Trustee table and create a record for the new meeting in the Attendance table?