Samuel, to answer your questions:

(1) It doesn't really matter whether or not you create your form from a TABLE or QUERY. If you need calculated values (like how I calculate a line total in my videos) then use a query. Otherwise a table is just fine.

(2) Yes, you are correct there too. If your Parent Form is based on the VISIT, then your subform could be based on diagnoses or procedures performed for that visit. In fact, you might want to have 2 or 3 different subforms (each based on a sub-table) for each visit: one for diagnoses, one for procedures, and perhaps another for medications subscribed. There's no limit.

Now, if you'd like to send me your database so I can take a look at it, make sure you ZIP it up or at least run it through a Compact & Repair so it's small. Email it to my personal email address: [email protected]. Make sure you leave the [599CD] in the subject line to bypass my spam filter.

Now, I can't promise that I can get to it right away, but I will look at it for you and make sure you're doing things OK. Make sure to send it in Access 2003 format as I don't have 2007 installed right now.