>Hi,
>
>We have a client who suspects fraud by an employee. The suspicion is that the employee changes the workstation date, then posts an inventory transaction dated well in the past, then pilfers the item. What I need is a way to:
>
>1. Prevent changes to the Workstation date/time OR
>2. Stamp all transactions with the Server Date/Time OR
>3. whatever else can prevent/flag this behavior
>
>Thanks,
>
>Ken.
Because you wrote this in Client/Server Category I assume you use some other DB like SQL Server or ORACLE.
You could add a field in your table with DATETIME type.
Then set default value for this field to be GETDATE() if you use SQL Server, or similar function for ORACLE.
Id you use VFP DataBase then you should use Sergey's suggestion (BTW Sergey's suggestion will work no matter what DB you use :o)))))))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.