AnsweredAssumed Answered

Totalling a Portal currency field

Question asked by MichaelLane on Nov 1, 2011
Latest reply on Nov 2, 2011 by MichaelLane


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?