Collecting Data Externally multiple records

[brew]

Hi,



I have a database which will contain sensitive data, but as part of that database there is a table which contains a case number (related the case table) and three different costs (Cost 1, Cost 2 & Cost 3), I would like to be able to use the email collection service in Access, to send our Finance guy the table, have him fill the costs for each case and send it back, without him having access to the rest of the db.

I have been trying to set this up but the html form the wizard outputs, is well... a form, only allowing one of each cost to be entered.

Is there a way to bend the email function to my will or am I going to have to do it another way?

[NTC]

I believe it would be much simpler, and equally useable - to email him an excel spread sheet that you set up.....where he inputs the info and returns to you.

Then you can easily import your excel data.

Hope it helps.