Dynamic printing and join tables
Hi,
I have several join tables set up because I need the many to many relationship.
So I have a Programme table that links through a join table to a Staff table for ex.
Prog< Prog_Staff > Staff
I am only just beginning to see about dynamic printing . I made a template in Word but apart from fields which are directly in the Programme table , nothing renders.
I used something like this from the Programme table:
{d.Prog_Staff[i].Staff.Name}
{d.Prog_Staff[i+1].Staff.Name}
What am I doing wrong?
17 replies
-
I haven't tried it out, but maybe try:
{d.Prog_Staff.Staff[i].Name} {d.Prog_Staff.Staff[i+1].Name}
I would think it would be at the Staff level since that is where you really want it to iterate.
If that doesn't work then I'll try to figure it out.
-
Ok, so I've had a chance to try it out and I'm able to get this from a table called Production:
the template looks like:
ProductionItem is a table that links Production (N:1) and Materials (N:1). Meaning you can only select a single record from Production and Materials in each ProductionItem.
So I was wrong to suggest that the [i] goes after the second reference field.
If Pro_Personnel is also setup similarly then can you modify your template so that only the following is in the first column
{d.Prog_Personnel[i].somefieldname} {d.Prog_Personnel[i+1]}
in the first column, remove data from all other columns. Replace somefieldname with a data field in Prog_Personnel. Do not use any reference fields.
If that works then you can add the reference field back in.
{d.Prog_Personnel[i].Personnel.PrenomNom} {d.Prog_Personnel[i+1]}
Let us know how it goes.
-
all this goes to prove that Ninox needs to have a proper built in report designer!
-
agreed
-
, if you were able to get your question answered, please mark the post answered when you have a moment.
Content aside
- Status Answered
- 3 wk agoLast active
- 17Replies
- 106Views
-
4
Following