Can I use Portal for this problem?
I am having a problem here, trying to get two records from one table to show up in another table.
First table is Equipment list, that has Equipment Name, cost of depreciation and Cost per hour using that equipment.
Then, other table is Estimation, that calculates the cost of material and cost of using the equipment.
So Equipment name (Key field) and Cost Per Hr are linked from the Equipment table to Estimation table.
Sometimes we use more than one equipment for the job. So far I don't have problem getting one equipment info using the ordinary field. How do I get the second equipment's cost per hr in the same record?
Can I use portal to display information from two different records?