On the dynamic dropdowns you first need to create an array source by having a recordset that returns everything. You can then add the OnClick code to the primary dropdown list which populates the secondary dropdown with the relevant data from the array. You can then apply the same logic to the second dropdown to populate the third etc etc
Try this for the javascript:
auto-sum-checkboxes.html
Cheers
Ian