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!