Hi,
I have a database of patients. Each patient can have two different kinds of prescriptions. The data structure of each script is very different, so they are stored in two separate tables [forms]. All forms have a common unique field I'll call it patientName for ease.
When I view a detail view of a patient, I want to see two filtered views inserted into the detail view - one is filtered view of scriptType1, the other filtered view of scriptType2.
I can get both views to work separately (e.g, disabling the other view), but not simultaneously - only one filtered view ever shows.
I found some description of using a nested view, but I didn't really understand how that is supposed to work and indeed I can't get it to work.
Surely this is not a unique problem - any solutions and ideas are welcome!