Linked data entry?

I

Ian AFFS

I want to have a form in my database that can be updated by the people to whom it relates. For example, consultants can change fields as they become aware of changes, so I don't have to chase them!
I don't want them to have total access to my database, just one form in it, and further, I want to vet their changes before making them gospel in the master database. Is this even possible? I have designed another database with just the one ofrm based on the on table, so they can make changes there, how do I then get their changes into my master database? Link them?

Many Thanks for any ideas
 
Top