Discussions

Expand all | Collapse all

Delimited child list within parent record

  • 1.  Delimited child list within parent record

    Posted 06-15-2018 20:01
    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!


  • 2.  RE: Delimited child list within parent record

    Posted 06-15-2018 20:17
    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.


  • 3.  RE: Delimited child list within parent record

    Top
    Contributor
    Posted 06-15-2018 20:35
    >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.