Cool, I think I got it working. Trying to do the "drag one form onto another" revealed that creating a form from the "middle" table gave an error even without a subform. Clicking around a little more revealed that there was an index defined for a column I had deleted earlier. Deleting that and...
Tell me, how careful would this make you want to be?
https://www.hhs.gov/about/news/2019/05/24/new-hhs-fact-sheet-on-direct-liability-of-business-associates-under-hipaa.html
Simply: I work for a hospital; this database tracks patient data; I do not want to go to jail. I know that field names...
So I have a database that looks like this:
I'm trying to make a form that displays one record from the "middle" table with a subform that shows all of the related records from the "inner" table. Unfortunately whenever I go through the Form Wizard to do this, I end up with an empty subfom and...