will look at these thanks

ok thanks

I figured out how to get my software to update without having to close the program I was able to add a button that did a windows refresh with flush...

I have tried the view and it seems to work ok execpt I am using a another software to access my sql database and I have to close it and...

OK I miss read and didn't realized what you were talking about it being in both the Header Table and Detail Table. I don't need to be in both...

because they want it to update the PONumber table with the total when they fill out the po so they dont have to go into the PONumber and put the...

what would you suggest then. I have a table called accounts as well would you use just the ID number for that account that coursponds with that dept and account...

The reason for account number being the line item is because each office has there own budget and they are broken into computer supplies, office furnture, copy supplies etc and...

Thats working ok except if there is already a amount in the subtotal in the PONumber table then it doesnt add them together.

I also get a error if trying to...

He is the information in the database.

On a view will it update the PONumber table everytime something is updated or added to the PurhcaseOrderDetail

Here is the script for the database.

but wouldnt you still have to ask everyone who there carrier is so you could reference it to that number. or is there a way just to run it the...

Can you give me an example and where to Add it in the database at

Right now I have been asking people who the phone carrier is and can just add it to the end of there number. But I was trying to find a...