Hello,
I am new here.
I have built a database with two tables (Vendors & Purchase Orders). The Venor table has the following fields and data types:
ID - AutoNumber primary key
Vendor Name - Text
Vencor Number - Text
The purchase order table has the following fields and data types:
ID - AutoNumber Primary Key
Requisition Number - Number
Vendor Name - Number
Amount - Currency
Org - Text
Obj - Text
PO Number - Number
Invoice Number - Text
Invoice Date - Date/Time
Blanket/Normal - Text
Voucher Signed - Yes/No
Check Number - Number
Check Date - Date/Time
Notes - Text
PO Closed - Yes/No
What I want to do but am not sure how to do is have a running total on my purchase orders form which will tell me how much money is left on each Purchase Order.
Each Purchase Order can have numerous enteries throughout the year with money coming off and I would like to be able to see at a glance how much is left on each but am unsure on how to proceed.
Any help would be greatly appreciated as I'm new to this