Service Order Database - Novice Looking for help.

[Patriot7470]

I have a design that tracks various types of service orders. There are 3 main categories, TCO, IJO, WO. Essentially I need to track the various charges ($) for each of these categories and have each charge update the balance for each account...sort of like a live update; and then display that balance in the Data entry form for new entries so that a requester can see if the allocated funding for the expense type is still available.

Additionally a seperate financial person would have access to add funds to an account either by changing the initial amount up or down (not preferred) or by adding funds to the account via a field in a seperate data entry form.

[orange]

To help us understand how about showing us your tables and relationships and any queries you may have.

[Patriot7470]

Thanks for the response. I have attached screen shots for the tables, querries, and forms in an attempt to help you understand my mess. I feel like I am so close to being done with this thing but just cannot get it over the hump...

[Patriot7470]

Screen shot for the Financial rep to update the Authority (funding allocation) or add a new allocation /authority.