mike60smart
Registered User.
- Local time
- Today, 00:20
- Joined
- Aug 6, 2017
- Messages
- 2,275
Hi
The attached screenshot shows how a Form would be created which :-
1. Allows you to select a Client
2. Allows you to select a Project Number and indicate the Type of BID and the Phase Costs
So now we would need a table to record all of the Cost Transactions for each Project.
tblProjectCosts
-TransactionDate
-PaidTo
-TypeofTransaction (Materials, Cash Advance etc)
-ItemPurchased
-ItemAmount
If you can work on this structure and get back to us.
The attached screenshot shows how a Form would be created which :-
1. Allows you to select a Client
2. Allows you to select a Project Number and indicate the Type of BID and the Phase Costs
So now we would need a table to record all of the Cost Transactions for each Project.
tblProjectCosts
-TransactionDate
-PaidTo
-TypeofTransaction (Materials, Cash Advance etc)
-ItemPurchased
-ItemAmount
If you can work on this structure and get back to us.
