Field survey help

[bjreb]

I have a table that is set to record a field survey. My employees are then sent out to remedy any problems found. What is the best way to enter this information. I would like to be able to view any work that was done by the emplyee.
Would the easiest way to do it be duplicating the row and allowing the employee to update it ?

Thanks

 

[ecniv]

Need a table something like:

tblRecordedVisit
RecVisitID - auto - pk
ItemVisitedID - number - long << this is the item/site/machine you decide
VisitedByID - number - long << employee who investigated
VisitedAt - date/time
Notes - memo

This can either be entered by you or by the employee (depending how you have the rest of the system set up...).


Vince