Assuming you've created a domain model with an Employee and an Expense entity with a 1 to many relatie between them:
If you click on an employee, you should open a new form with a data view containing the employee you've just selected.
This data view should contain a data grid. There are two ways to show only relevant expenses here:
Thanks Rom. I can't seem to find a Data Grid for Mobile forms, only for Web forms. Is there an equivalent for Mobile?
Sorry Guys, but I'm going round in circles here. Have tried as follows: In all cases I've started with a list view of employees, with a click action that either... 1 - shows a dataview of the (correct) selected employee, and a listview in the same form to show expenses; or 2 - shows a dataview of the (correct) selected employee, and has a Show Form widget that points to Expenses form; or 3 - the click action on the employee list goes direct to the Expenses form. In all cases, if the Expenses datasource has no xpath constraint, then all expenses for all employees are shown. If I include the constraint [xxxModule.ExpenseDetail_Employee='[%CurrentObject%]'], then no expenses are shown. This should be so simple (and i'm sure it is) but its just not falling into place!! Note - this is for MOBILE forms, not WEB. Thanks