parent to children action in offline app

0
Mendix beginner here, having difficulty with going from a line in a data grid listing invoices to a data grid of line items for that invoice.  The invoice line items _could_ be on the same page, but a separate page would be better, because some invoices could have hundreds of line items. Because this will need to support offline mode, I understand that microflows are not supported.  A Mendix video/presentation says "Navigate via associations" but I don't see any way to do that.  I have a parent-child association in my data model and the invoice number is present in both invoice and invoice_line_item entities. Any pointers would be welcome.
asked
2 answers
3

On your Invoice DataGrid you add an Edit Button to open a page with a single Invoice.

On the Invoice Page you add a DataGrid with DataSource = Database over Association.

answered
0

This is not an answer, but a comment with an image:

So although it appears that I have the page set up appropriately (see below), while the data from the invoice (parent) displays correctly, the invoice_line (child) data never appears. Am I missing something? 

I am coming to believe my problem is due to a fundamental misunderstanding about how Mendix handles data.  I imported the data for my two entities from excel spreadsheets.  Each entity has an invoice_number.  But defining an association between entities in Mendix doesn't take into account shared attributes.  Is there any way to modify or expose this behavior?

Since my goal is to develop an application that can operate in offline mode, using XPath or microflows to connect a parent with its children is forbidden.  Given my constraints, is there any way to make this work?  Or should I be looking at non-Mendix solutions?

Thanks.

answered