Portal in Question
Hi all, reposted my request for help on my database:
PROJECT (table): Client, Job Description, Main Category Costing whereby Main Category Costing is a portal, listing of the various main cost items, description and costs.
Main Category Costing (table): Sub Category Costing is a portal, listing the various sub cost items, description and costs.
Sub Category Costing (table)
All 3 tables are related via keyQUOTE_ID meaning PROJECT <=> Main Category Costing <=> Sub Category Costing
The main layout shows PROJECT (table) records which is the overview of each project.
I've another layout which shows records of Main Category Costing table and on this layout, I've a Sub Category Costing portal created.
Qn: I would like to have another portal listing past projects displaying sub category cost items, description and costs.
Hope this illustration is clear. Thank you.