I have a Access file.
I want to create a form which will show me list of all Projects from tblproject table in a dropdown.
Selecting any Project will show me two different lists. All associated records from tblmilestone and table and all associated records from tblfee table. Finally in last list it will show three columns. Sum of amounts from tblmilestone table and sum of amounts from tblfee table and difference of these two.
Attached is the Access Sheet. Should be max 30 minutes work for somebody who knows access.