Can I take data from a report to affect data in a table?
I'm trying to build a database application which requires all the totals of a field across all records which then affects the data in another table.
What I'm trying to do is build an application for calculating the manufacturing needs in Eve Online. So basically I have a table for minerals I have in stock at various stations that all need to be totalled up. Then that total is subtracted from the amount of minerals I need to complete a ship build or whatever I'm building.
Is this possible with reports or do I need to find another way?