I have tables related: Patient < Calc < IO < Druglist > Drugs relationships.
On the Patient layout I want to have 3 Druglist portals, 2 will list drugs that are given by Routes 1 and 2. The 3rd portal will list drugs given by Routes 3 & 4.
Drug doses are summed in IO depending on the combination of Routes chosen in Calc::Route.
Obviously I need to be able to add new records to the overall Druglist, from each portal, where the portal will have a valuelist showing only those drugs for that 'portal route'.
Problem: I'm stumbling at the first hurdle of getting Druglist records to show in portals. I can get all to show, but filtering causes none to be shown.