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!