Conditional Expansion & Conditional PICK

[customaware]

Had a bit of discussion recently about the need to condition the Checkbox for a PICK Query

Here is a Demo.... Import and Run it... there is some sample data.

Parent Data is some Continents
Child Data is some Animals

Looking on the Child Tab, you can see that Cat and Gold Fish have been tagged as Not Selected.

So, to test out.... on the Parent Tab.... Edit Asia and Click to Associate Child Data at the bottom left of the Child Query.
A PICK Query is displayed and you can see that all Animals except Cat and Gold Fish can be selected.

So, now Select Panda Bear and Elephant..... then Click Continue

Now back in the Parent, you can see the Panda Bear and Elephant Children Reocrds.

Click Save.... Now you will see the Black Expansion Triangle at the Left of the Asia Record indicating that record has Child Records and Can be Expanded.

For some reason the Forum will not allow me to upload the bsv Zip file....

So here is a download link in the meantime.

https://file.io/RloH3zmSsQ3D

Looking forward to see many of you again at the Conference..... Only 3 Weeks to go! Whacko!

[MESSI]

Hi Mark,

Please check the download link, it's not working!

Thanks

[customaware]

Ok..... The Forum would not allow me to upload a zip file for some reason.

So here is the file..... Download it and change the .txt to .zip.... Enjoy!

QueryTricks.txt

(46.13 KiB) Downloaded 52 times