I am preparing database for a project. Background as below:
- Project has Engineers with unique ID.
- Each ID has specific period of assignment (in months)
- Each ID has specific rate of billing
Action Taken so far:
- I have created Master table with all experts ID, Position, Manmonth and Billing Rate
- I have created second table with ID, mammonth used month after month
What I want to Achieve:
- I want to create invoice with following information included;
1. ID, Contract Manmonth, Billing Rate, Cumulative Manmonth claimed upto previous month, Manmonth claimed in current month, Cumulative mnmonth claimed upto current month, And balance manmonth
Can someone help how to proceed, as I am new to Filemaker?