It's not really practical. If each group were in a separate portal--even a filtered portal, the total for each portal would then give you a sub total.
But inserting a sub total on its own row in the portal would require inserting a record and putting the sub total in a number field. That's not impossible to do, but loads your portal table with extra records and creates a major challenge in trying to keep the sub totals up to date when records are added, deleted, or changed.
I am not keen on the mulitple portals as it will make the form messy i.e some records may have no entrys or just one entry type in these portals and some records may have 15 differnt types of entries. so i would need to set up many portals just incase and this is just clutter.
as an instance I want to be able to group records by supplier name and subtotal for that supplier and a record may have many different suppliers for different things, but i would like to subtotal each supplier.
I need to give this more thought on what I am trying to acheive, I think i need to get the portals planned properly so that the sub totals and totals can be done on the main form.
Is it possible to have a portal which lists related records to the main form and for each entry created in this main portal a new portal would be created on the form in a list of portals.
the idea being I would create a record in the first main portal this will be the main supplier list and for each supplier added to this portal a new portal would be created which would be to enter product details and costs and list all the entries for the individual supplier.
this would then let my sub totaling system work i think.
what do you think?
You can't "create" a portal dynamically, but you can have one portal where you see and edit a list of Suppliers and a "detail" portal that lists records related to the current record in the Supplier portal. Edit a field in a different portal row and the detail portal updates to list records for that supplier and so forth...