Posted 8 September 2017, 1:40 pm ESTHaving just begun to glimpse the power and flexibility of fpspread, I'm sure there are a number of ways to skin this particular cat. BUT - lacking even the most rudimentary knowledge of each/every capability of fpspread, I'm uncertain ast to the best (meaning least amount of coding to achieve the desired result) approach. So I'm inviting any (and that means ANY) comment that might lead me to the optimum solution.
I hope the following is a reasonable analogy for the project:
Acme Inc. manufactures a number of PRODUCTS including Doo-Hickeys, Gadgets, Thing-A-Ma-Jigs, and Widgets. Each of those products is assembled from assembled component MODULES including power module, cooling module, viewer module, mobility module, heating module, analyzer module, printer module, etc. Any given module may be used in assembly of one or more products - thus the product-module relationship is one-to-many. Of course, not all modules are used in any given product.
Each module is assembled from discrete COMPONENTS, including Resistor1, Resistor2, Resistor3, PrintHead1, PrintHead2, PrintHead3, CRT1, CRT2, CRT3, etc. There are an unlimited number of discrete components within each type. The module-component relationship is therefore essentially many-to-many.
All data is, of course, contained in a database. Tables: Product, Modules, Components as follows:
Now, as to the fpread layout and desired functionality:
The ParentRow will display the PRODUCT, ie: Doo-Hickey, Gadget, Thing-A-Ma-Jig, and Widget and will be expandable.
Upon expanding the ParentRow for any give PRODUCT, I wish to have the grid display the discrete COMPONENT list. I do NOT wish to see anything from the MODULE list.
In its "natural" layout, the grid seems to want to display something like this (with headers at each level):
---> PowerModule1 $45.00 120VAC
---> PrinterModule3 $30.00
---> CoolingModule4 $80.00
BUT WHAT I WANT TO DISPLAY IS (with only one header for the COMPONENTS list):
How might I most easily achieve this?