Jump to content

All fields visible in Table View but not in Form Portals


Recommended Posts

  • 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

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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