June 14, 200619 yr 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
Create an account or sign in to comment