I have produced a document for a friend which has a table for data and a
table for totals

My document basically is all done as word and using the vba to do
caculations and check data in the table for integrity.

This has worked fine for the last year but now he needs another controlling
element... and I am not sure if you be thinking of writing the input section
in to a form rather than directly to the table.

I basically now need to add a combo box to each row of the table all the
combo box will be doing is offer choices of calculating the data
ie dropdown1 = vat thus add vat to the totla
  dropdown2 = cis4 add vat  to the gross wage and then -18% of the gross
wage and add together
  dropdown3 = cis6  -18% off the gross wage

but i thought if i can get this right if there is further type of deduction
/ calculation required it just gets added on part off the dropdown

so firstly is there a better way should i be using a form to input data and
then put it to the table.

Is it ok to have a table which has a column of the same repeated dropdown in
each row.... how can i achieve this.. .as i have not embarked in repeating a
single dropdown on the same page before

Another point to remember is the document core data doesnt change all that
often
ie a man joins the company every week he will get paid thus his deduction
details will be the same everyweek after being created ; also his name wont
change ; his job number wont change

Please advise how i should be looking at the project now as i think i might
a bit more of application rather than document manuliation.

All advise is welcome and if people have any examples of similar things so i
can see how visualy they have intergrated them that would be a great help...

Many Thanks