Once a record is committed, is it possible to restrict modification of the key field's value
I am a newbie to Filemaker (FMPv11) and am working on creating an asset management database (used for managing a tape vault where we can track the location of an asset based on it's barcode information). I'm having trouble figuring out a specifc field behavior and am hoping you can help point me in the right direction. In my solution, our staff needs to be able to enter an asset barcode number into the primary key field. Once commited, I'd like the field to be locked so users can't accidentally modify the data. I however, need a way for them to be able to intentional override the lock if they need to modify the barcode # (we often need to modify the barcode to use our client's barcoding convention instead of our internally generated barcode). I envision it working this way:
User enters barcode# in primary key field
After field is commited, field is locked
If user tries to enter the primary key field again, a dialog box opens up asking/confirming they wish to edit the field data. If yes is selected, user is allowed to mofify field data until commited again.
Any help on how to set this up would be greatly appreciated.
Thanks in advance.