Combine lines from multiple tables into one
I'm a contractor who uses Ninox for estimating and project management.
My structure is as follows:
"Estimate" table contains multiple estimate items that come from the "estimate items" table. Each estimate item contains a list of materials in the "item details" table. Each material comes from a "materials" table.
The estimate item is like "shower tiling" as an example and it includes tile mortar, tile, silicone, whatever.
I want to be able to generate a materials list that has the materials from all estimate items like "shower tiling, floor tiling, door installation"
Since all of the items are stored in "item details" but are referenced in "estimate item" I basically just need a way to get all "item details" that are linked to an "estimate item" that is linked to an "estimate" and print them in a report.
I know I can get them all separately by doing "print report" on estimate item and then "print all" but it's unorganized and Ninox is so powerful I know there's a way to do it.
Thanks for the help!
Reply
Content aside
- 1 yr agoLast active
- 60Views
-
1
Following