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.

Add new records to parent, child, and grandchild in one layout

Featured Replies

  • Newbies

Is it possible to add a new record to the parent table and then add a new record to the child table and then add a new record to the grandchild table from inside one layout?

Parent: Students

Child: Admission

Grandchild: Agency Admission

I have another table called Agencies and the Agency Admission is a join table between Agencies and Admissions. One student can have multiple admissions and multiple Agencies can be involved in one admission.

Any help is greatly appreciated. Thanks.

It's not possible to have a portal in a portal. So, I would probably have a button on Student "New Admission" which creates the new Admission record and navigates to its form view. On the Admission form view, I would have a portal to the "Agencies Involved" - your AgencyAdmission join table. If you only have a limited number of Agencies from which to choose, I'd use a popup menu in the portal of AgencyID Name. If you have more than 10 Agencies, use a popup select window.

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.