Delimited child list within parent record

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
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!
Photo of Patrick Dunn

Patrick Dunn

  • 130 Points 100 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,994 Points 20k badge 2x thumb
>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.