June 18, 200421 yr Newbies I'm kinda new to Filemaker. I'm trying to write a simple report card thing for my mom. I have a few tables, one is for students and it has all their contact info in it. One is for the actual report card. I have the students table linked to the report card table on StudentID, which exists in both tables. I'm trying to write a script that when a new student is entered, a new blank reportcard is created for them that is linked to their studentID. For the life of me I can't figure this out. I looked on the boards and found some stuff about Portals, but honestly I'm kinda lost as to what those do besides display related info. Any help would be really appreciated. Thanks.
June 18, 200421 yr You need no portal for this (but you could use one otherwise). Mainly your script should start on a layout which belongs to the students table, create there a new record, copy the new StudentID into a global field, change to a layout of the Reports table, create there a new record and insert the StudentID. The script would roughly look like this: Go To Layout (NameOfLayoutBasedOnStudentsTable) New Record SetField(g_IDtransfer; StudentID) Go To Layout (NameOfLayoutBasedOnReportsTable) New Record SetField(StudentID; g_IDtransfer)
Create an account or sign in to comment