Totalling a Portal currency field
My database has 2 main tables: Jobs & Stock. The tables have no common fields so I also have a Join Table to create the Relationship.
I use the Join Table to allow me to populate a Portal (Jobs layout) in which Stock details are added to the Job.
Is there a method to total the Currency field from the Stock table to identlify the cost of the stock items used by a job?