Problem setting up privileges

[David Mosedale]

Hi,

I am trying to set up a set of privileges and having problems. I have a database (FM 7; Mac OS X) that is used to prepare an order, which is then emailed to our finance dept.

I have just two users - admin and someone else. I would like to give them permission to generate an order, and modify it to their hearts content until it has been emailed. This is all fine. However, after the email has been sent I would like them to be able to alter just two fields on the record, but not the rest of the record. This is where I have the problem. I have been able to set it up so that they can modify the record only when it meets one of the following criteria:

1. Has not yet been emailed

2. Field xxx is empty

3. Field yyy is empty

Unfortunately this means that for 2 and 3, the rest of the record can be modified as well. Since they need to be able to modify the rest of the record prior to the email I cannot do it within the layout. So how do I give the user access to:

1. All fields on all orders not yet emailed.

2. Only fields xxx and yyy on the rest.

Sorry if this is complex, and hope you can help!

Thanks, Dave

[transpower]

One way would be to transfer the user to a duplicate layout but which disallows entry into all fields except for xxx and yyy. There may also be a way to do it with custom record privileges and view/edit selected fields--maybe LaRetta would know how. We had a similar discussion (but not identical) several months ago.

[David Mosedale]

OK - I will have a look at that. I guess it is possible as I could use a script to send the user to one layout if the email has not been sent and a different one if it has, but the xxx and yyy fields have not been completed.

If anyone else has a really smart solution using privileges, you better be quick as I am about to use this one!

Thanks for your help, transpower!!!