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.

How do I Make a Related Table Relate ???

Featured Replies

  • Newbies

I have a "Parent" and Child" table that look fine in the Relationship Graph. Each unique identifier is connected-- The parent field auto generates a serial number; the child field does not.

I need to be able to generate records in the child table without adding a new record to the parent table.

How do I proceed? I've tried using a portal, but can't figure out where or how to place the child field. Boy I am frustrated.

Although I'm 60, I think I have enough brain cells left to manage this task. But I learn best when someone walks me through each step... simply and clearly. (As a retired English teacher, I think I have a chance at this!)

I'm using FMP 9.3 and am adding a few more gray hairs (and losing others) each day this issue keeps me bamboozled.

Your thoughts... PLEASE.

Barry Sommers

[email protected]

718-983-6683

Staten Island NY

You can create child records directly in the portal (provided you have enabled automatic creation of child records in the relationship's definition), by filling ANY child field placed in the portal.

Alternatively, you can create child records in the child table - but then you need to assign them to a parent, or they will remain orphans.

Try both in the attached example.

Simple.fp7.zip

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.