Forum Discussion
RichardBrett
Qrew Trainee
I think Yearend has fried my brain, so apologize for the constant clarifications.
Of course, you are correct the child is not required to have a parent.
I have played around with a couple of different ways.
If I do a Two Table setup I don't see how to select existing data into the parent.
Thank you again for your help!
Of course, you are correct the child is not required to have a parent.
I have played around with a couple of different ways.
If I do a Two Table setup I don't see how to select existing data into the parent.
- Is it just manually creating a blank parent and then going to a report on the child table that filters out any with an existing parent and adding the new parent ID?
- Is there a way to do that directly from the parent?
Thank you again for your help!
QuickBaseCoachD
6 years agoQrew Captain
I think I understand.
You just need two tables and one relationship. One Combination has Many Samples. What is confusing you is that the samples already exist so it�s a matter of selecting Samples to associate to the combination and not creating children like most Apps do.
There are two solutions here.
You can either look at a report of Samples which are not allocated to. Ombinations and edit then one by one to select a combination. The drop down list on the sample form can be limited to Combinations which have fewer than 4 Sample children. You do that by making a report filtered that way and setting the form to use that report as the drop down list.
But I can see that what you really want to do it to have a way to launch off the Parent Combination Record and select up to 4 unassigned Samples.
I can help you set that up but it requires the creation of some URL formula fields that are beyond the scope of what I can explain in this forum.
If you would like some help in setting this up, contact me via the invitation in my website.
QuickBaseCoach.com
You just need two tables and one relationship. One Combination has Many Samples. What is confusing you is that the samples already exist so it�s a matter of selecting Samples to associate to the combination and not creating children like most Apps do.
There are two solutions here.
You can either look at a report of Samples which are not allocated to. Ombinations and edit then one by one to select a combination. The drop down list on the sample form can be limited to Combinations which have fewer than 4 Sample children. You do that by making a report filtered that way and setting the form to use that report as the drop down list.
But I can see that what you really want to do it to have a way to launch off the Parent Combination Record and select up to 4 unassigned Samples.
I can help you set that up but it requires the creation of some URL formula fields that are beyond the scope of what I can explain in this forum.
If you would like some help in setting this up, contact me via the invitation in my website.
QuickBaseCoach.com