Select Multiples in Cascades

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
PointsWell
Posts: 1460
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Select Multiples in Cascades

Post by PointsWell »

Hi

I am currently trialling AwareIM and trying to get multiple cascades to work.

I have three Business Objects:
Role
Sub Role, and
Class

Roles can be Buyer or Seller

A buyer can be
Distributor
Onward Supply

And then an Onward Supply could be
Manufacturing, or
Service

My challenge is that

1 Role can have many Sub Roles
1 Sub Role can have many Classes

If I set the cascade to be 1-1 all the way through then I can manage to get everything to show on the basis that

Code: Select all

SubRole.Role = [FormName].Role  and Class.SubRole=[FormName].SubRole
However if I change it to be 1-M relationships using

Code: Select all

SubRole.Role=[FormName].Role 


displayed using checkboxes on the form this works fine but the subsequent

Code: Select all

FIND Class WHERE Class.SubRole IN [FormName].SubRole
This returns nothing and doesn't even format the Checkboxes properly.

If I use = instead of WHERE IN then it doesn't resolve but does show the checkboxes correctly.

Does anyone have any suggestions?
PointsWell
Posts: 1460
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Select Multiples in Cascades

Post by PointsWell »

Also...

The form is not rendering correctly when I have the checkbox table on the page.

It overlays the navigation buttons. I have tried adding blank rows after the checkboxes and have tried adding another field after the checkboxes and it does not move the buttons to below the table.

Default Placement
Image

Bottom of Panel Placement
Image
Post Reply