Hello, Everyone! First post here. Trying to figure things out by myself, but this one’s been tough.
Here’s the issue: I’m creating a database to keep track of production inputs (i.e.: personnel, materials, tools, etc) required to accomplish a specific task.
I have a (rather rookie) C#-oriented mindset, so I might well be getting it wrong, but here is my hierarchy as I planned it:
- A given SERVICE contains a NAME, a CONSTRUCTION SITE, a LIST OF TASKS and a LIST OF INPUTS (tools, in this case, which could be applied to more than one TASK)
- A TASK contains a LIST OF INPUTS (personnel and materials inherent to that specific task)
- An INPUT contains its own things, like DATE, AMOUNT, PRICE, etc.
I have created a Repeating Group which I refer to as INPUTS TABLE, since that is where I want to display the data pertaining to each INPUT, regardless of the SERVICE and the TASK it belongs to. So far, so good. All I did was define the Type of content as INPUT and the Data source as a SEARCH FOR INPUTS.
The problem shows when I want to display the SERVICE and the TASK to which that INPUT belongs in the same Cell of the Repeating Group.
I have tried placing a Text element with Dynamic Data set to SEARCH FOR SERVICE’S NAME, but I get no option to set its Constraint as the Current Cell’s INPUT or something of the sorts.
The expected result, as I stated earlier, is to get on the same Repeating Group’s Cell the SERVICE and the TASK which contains that particular INPUT.
Any clues on how I can achieve that, please?
Thanks in advance!