Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
np,
A Parent can have many children, but a child may only have 1 parent.
ie a Sample if the sample is setup as a Child in a relationship, it may only be attached to one parent as a child.
So the only Samples that are available to use are where there is no parent. I like to set up a field on the Parent called [Parent Exists?] as a formula checkbox field with a formula of true and look that up down to the Child. Just in case the parent gets deleted, and yet [Related Parent] sill has value in it but the child is now once again an Orphan.
A Parent can have many children, but a child may only have 1 parent.
ie a Sample if the sample is setup as a Child in a relationship, it may only be attached to one parent as a child.
So the only Samples that are available to use are where there is no parent. I like to set up a field on the Parent called [Parent Exists?] as a formula checkbox field with a formula of true and look that up down to the Child. Just in case the parent gets deleted, and yet [Related Parent] sill has value in it but the child is now once again an Orphan.