need advise on merging

[Jean-Paul]

Hi,

In our company we have about 15 sales-managers.
Each visit companies.

They all have an access application to organize and report.
After visiting a company they are supposed to write down some remaks.

I would like to centralize this information all in 1 database.

What do you, expersts suggest to do?
Can I easily merge the data of each person into one database?

All ideas are welcome?

Thanks
JP

 

[Mike Painter]

Make sure that you have something that gives the records a unique ID.
A random autonumber pretty much guarantees this.
You can then use an append query.
It could also be done by having them send an email with the same subject
line which you could parse and get the data.
Managing the incoming files will probably be the biggest headache.