Good morning, I am writing to ask about how to do (in PlanetPress Connect) a datamapper based on a connection to MS Access that is able to load the records that returns the query in 3 levels of nesting in the DataModel.
I explain, the Access table to which I connect contains 3 kinds of data: commercial (first level) clients (second level) invoices (third level)
I have established the “Boundaries” in OnChange of “idComercial” (primary key of first level).
What I intend is to load the commercials in “record” of the DataModel, the clients in “record. Client” and the invoices in “record. Client. Invoice”.
The problem I find is that it is not easy to build more than two levels (“Record” and “record. Client”).
Can you help me?
Thanks in advance,
