A Secured Field after fill

[Pianotech]

This is in paradox 9. I'm building a database for salesmen in a music store. I need the user to put his name in the salesman field when he/she opens a new recored but that field turns into readonly when it is written to the record so other salesmen can't overwrite his name. I've experimented with several objectpal codes and have had no luck with it working.

Thanks

Alan

 

[Guest_imported]

Alan,
Is it possible to do this by having each user assigned a different log-on ID? Let your code insert the Salesman's ID / Name in the background, based on the log-on ID.

Alternatively, in your Salesman's name field, set the field to readOnly if the field has data in it using the arrive method for the field, e.g.
method arrive (....);
if self.value = blank() then
self.readOnly = false
else
self.readOnly = true
endif
endMethod
HTH
Padraig

 

[Pianotech]

Thanks I'll try it. It looks like I was close except I was going at it backwards.

Alan - Pianotech

 

[Guest_imported]

Also, make sure your user's can't open and edit the table directly.