Skip to main content
Question

Delimited child list within parent record

  • June 16, 2018
  • 0 replies
  • 23 views
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!
    This topic has been closed for replies.

    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.
    Terms & ConditionsAccessibility statement