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.

All fields visible in Table View but not in Form Portals

Featured Replies

  • Newbies

Greetings;

New to FM Forums, so I hope I’m posting correctly.

I have two primary tables  BONUPROGRAMS (BON__BONUSPROGRAMS_tog) & CLASSES (CLA__CLASSES_tog)
I have a table BPViews that is a portal to each of the above tables (bon_BPV__BPVIEWS) & (cla_BPV__BPVIEWS)

My objectives;
When I populate bon_BPV__BPVIEWS::BPVClass, I want to populate cla_BPV__BPVIEWS::BPVClass
When I populate bon_BPV__BPVIEWS::BPVDate, I want to populate cla_BPV_BPVIEWS::BPVDate
When I populate cla_BPV__BPVIEWS::BPVName, I want to populate bon_BPVIEWS::BPVName
When I populate cla_BPV_BPVIEWS::BPVDate, I want to populate bon_BPV__BPVIEWS::BPVDate

My relationships;
BON__BONUSPROGRAMS_tog::_pkBonusPrograms <> _bon_BPV__BPViews::_fkBonusPrograms &
BON_BONUSPROGRAMS_tog:::BPNAME <> bon_BPVIEWS::BPVName

CLASSES_tog::_pkClass <> cla_BPV__BPVIEWS_fkClasses &
CLASSES_tog::ClassCodeString <> bon_BPV__BPVIEWS::BPVClass

bon_BPV__BPVIEWS:BPVClass the value list ClassCodeString using values from CLA__CLASS_tog::ClassCodeString
cla__BPV_BPVIEWS::BPVName uses the value list  Bonus using values from BON_BONUSPROGRAMS_tog::BPName

However, when I view bon_BPV_BPView in Form View the bon_BPV__BPView records are visible but the cla_BVP__BPView records are not visible
And, when I view cla_BPV__BPView in Form View the cla_BPV__BPView records are visible but the bon_BVP__BPView records are not visible.
I’m thinking I need to somehow relate

An interesting thing I noticed is when I view bon_BPV__BPViews in Table View I see the missing records from cla_BPV__BPVIEWS & when I view cla_BPV__BPViews in Table View I see the missing records from bon_BPV__BPView.


cla_BPV__BPVIEWS::Class to bon_BPV__BPVIEWS::BPVclass
bon_BPV__BPVIEWS::BPVName to cla_BPV__BPVIEWS::BPVName
cla_BPV__BPVIEWS::BPVDate to bon_BPV__BPVIEWS::BPVDate
bon_BPV__BPVEWS::BPVDate to cla_BPV__BPVIEWS::BPVDate

I hope I explain it well. What am I missing or doing incorrectly?

Thanks,

Scott

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.