[SOLVED] Selecting multiple records with integer key 1:many:many selection
Posted 18 June 2019 - 03:49 AM
all three of these fields ate int(11)
Normally these elements will behave like this:
Select a single regionID.
--> Select a single encounterID based on the regionID.
----> Select a single community ID based on the encounterID
These selections work great.
However when I want to create a report, I want to select like this:
-->Select a single regionID
----> Select any number of encounterID records based on the regionID
------> Select any number of communityID records based on the selected encounterID records.
I tried using a varchar field to hold each of the encounterID keys but that doesn't seem to work when I want to perform a lookup with the wizard.
Basically, I need to store a number of integers in a field so that I can select a number of integers in another field based on all of the integers in the previous field.
Can someone point me in the right direction?
I'm sure there's a way to achieve this in PHPRunner, but can't seem to see the forest because of all the trees.
I'm using v10.2
Posted 18 June 2019 - 07:54 PM
On the primary table, the regionID, encounterID and communityID are all set to int(11)
On the report table, the regionID is set to int(11), the encounterID and communityID are set to varchar(250)
On the lookup wizard, I set the encounterID on the report table to checkbox and the advanced dependency set for the report table regionID to the regionID in the encounter table. In my thinking, it should then select all of the encounterID records associated with that regionID. But, there are no checkboxes created. In fact, nothing is created for the encounter element.
I agree that the varchar should be able to hold the comma delimted list of encounters, but I can't seem to get there.
Posted 19 June 2019 - 04:32 PM