Forum Discussion

RichardBrett's avatar
RichardBrett
Qrew Trainee
7 years ago

Re: Enforce single use of a record in a relationship

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. 
  • 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?  
Using 3 tables it appears to work by using a filtered report in the join to filter out any that have existing parents just cannot do it from grid edit.

Thank you again for your help!

2 Replies

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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
  • RichardBrett's avatar
    RichardBrett
    Qrew Trainee
    7 years ago
    Thank 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.