>I have the following question, regarding multiuser.
>
>My program have to gather rawdata from several tables, then
>to calculate some end result.
>The table content is employee,date enter work hour enter work,date leave work,hour leave work,
>department and job.
>From this rawdata I calculate how many hours he have been working.
>This is done by the user. He choose fromdate-todate and push a button "calc hour".
>After calc. the user approve if the employee is to have payed overtime, and is correcting
>hours if something is wrong.
>
>How does I solve this in a multiuser env???
>If another choose different date, the end result is different.
>
>Best regards
>
>Per Simmersholm

Per, you need to limit the number of people who can edit a particular person's data to that person plus his supervisors who approve the hours/overtime. Also, once the data is entered, then CHANGING it should require a fairly high security level.

These limitations can be done with a login security level. For example, if everyone under supervisor level has security 3 and supervisors have security 5 then only Person A (level 3) and supervisors can edit Person A's data. Only Person B (also level 3) and supervisors can edit Person B's data and so forth.

HTH
Barbara