What am i doing wrong?

[Serenity]

3 tables

main – invoice information

billlineitems – line items

feetype – typescost of line items

issue – list of line items comes from list of fee types

With the exception of discovery copying – all other amounts are variable

Therefore, require it to automatically calculate if photocopying, otherwise be manually entered

Have to change the calculation to a look-up so if the price changes, it doesn’t effect the previous bills retrospectively.

The main issue is it doesn’t work well in a portal, and from the source table you need to click on refreshcashe results for it to update.

For example:

Add A4 Black and white - 10 pages. Works fine. But if you change A4 Black and white to one of the others (say A3 colour) it won't update the amount etc.

TIA

(P.S I've ripped it from a larger solution so there might be some dodginess : )

delete.zip