Newbies ColdZero Posted June 18, 2004 Newbies Posted June 18, 2004 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.
dbruggmann Posted June 18, 2004 Posted June 18, 2004 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)
Recommended Posts
This topic is 7520 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now