Forum Discussion

PatrickDunn's avatar
PatrickDunn
Qrew Assistant Captain
7 years ago

Delimited child list within parent record

Hello. I have two tables. Parent table is Manufacturer (key field is Manufacturer Name). Child table is Model (key field is Model Name). In the child table, there is a field labeled "Status" (active or inactive). Within the Manufacturer table, I'd like to have a field that is a semicolon-delimited list of every Model Name related to a given Manufacturer where the status of the Model is Active. I'm unsure that a reverse lookup / relationship(s) will do the trick, because A) each Manufacturer could have dozens of Models, and B) the key field of the Manufacturer table is not record ID#. Thoughts? Thanks!
Relationships
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    There is a way with the IOL technique and coding to do that, but I believe it will only work on a form, and not on a report.  So, in my mind its not worth doing that way, because if you have a form, you can just have an embedded report of the Active Models.

    As long as the key field of the child table is numeric, such as [Record ID#] the reverse lookup will work.  However, if there could be "dozens", or children models, then that would take "dozens" of loops of reverse lookups and would affect performance depending on the amount of data in the app.
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      7 years ago
      >There is a way with the IOL technique and coding to do that, but I believe it will only work on a form, and not on a report

      Script works everywhere - it is what powers the web. This is totally possible to do with script. Script, script, script and more script.