Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Creating Related Table Entries

Featured Replies

  • 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.

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

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.