Forum Discussion
RichardBrett
6 years agoQrew 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!
- QuickBaseCoachD6 years agoQrew CaptainI 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 - RichardBrett6 years agoQrew TraineeThank you.
I posted some clarification and new information given to me tonight. It is outside of my original question.
I need to relook at what we were going to put together for it and see if I can come up with something that will work but if not I will see if they will give me an allowance for outside assistance and reach out to you via your website.
Thank you again for taking the time to look at this.