Forum Discussion

TateForgey's avatar
TateForgey
Qrew Assistant Captain
5 years ago

What is the best equivalent to the Parent-Child Trick for connected tables?

I need to get data from a system where they are having a tough time creating properly structured CSV exports.  Specifically, they have questionnaire data where each question response in each questionn...
Quickbase Sync
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
I only partly understand your question,  but regarding this:

So far so good. I then went to create the reverse relationship with this new field in hand and DREAD - that field is not available to use as a reference field!

So just make a mirror field with a formula field of the [new field in hand]  and use that for the relationship.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • TateForgey's avatar
    TateForgey
    Qrew Assistant Captain
    5 years ago
    Genius!  My mistake was thinking that the summary fields I created couldn't be used as reference field in the relationship because they were not part of the connected table when really that was not the case at all.  When I created formula text versions of those fields they were available as reference fields, which allowed me to use them for the reverse relationship and pull in the questionnaire data.

    As always, Coach, thank you so much. It may be "No problem" for you but it is a great service for the rest of us.

    ------------------------------
    Tate Forgey
    ------------------------------