I have a simple app for creating transport and invoicing documents, when creating the pdf of the invoice I need to indicate the transport documents and the items relating to each document, with the start function the first table was simple, but I can’t to select only the items of the transport documents linked only to that invoice. Is there a missing table “related” between the invoices and the articles?
This is the function I’m trying to create, is there anyone who has already made a similar template? I think it’s quite common but I can’t get out
<<start:SELECT(righeDdt[ID_righeDdt],([ID_alfa3cod] = [_THISROW].[Alfa3Cod]))>><<[ID_righeDDt]>><>