We use filemaker 8.5 to also make invoices and actually want a button when we are ready to lock or open the record, is that possible and if so how?
What do you want the button to do? Simplest may be to have a layout where all the fields don't allow entry, could even be a layout with merge fields. Put a button on there to 'Edit Record'. Button takes you to the same layout or similar layout where all the fields you want to allow entry are available.
Put a button on the second layout 'Save'. The save button commits the record, and returns the user to the original, non-editable layout. I actually use 2 buttons, Save, Cancel or Revert, and prevent the user from committing (either with a clear button over the entire layout or an OnRecordCommit trigger) the edited record unless they use one of the buttons.
Save-would commit the record, return the user to the original layout.
Cancel or Revert-revert the record and return the user to the original layout.
Hi Steve To change the Layout or nothing, it is what is filled in the record and so I press a button or put in a field 1 that it is locked
See if this helps
Did you notice that the OP has FileMaker 8.5? Might make it difficult to ope a .fmp12 file.
A simple lock expression can be added to the privilege set for the table where you want this lock:
IsEmpty ( Lockfield )
Where LockField is a field in the same table.
The field can be either formatted with a single check box value of 1 or a button can use set field to set the field to a value.
A script that runs "with full access privileges" can be used to do this:
Set Field [YourTable::LockfIeld ; "" ]
to unlock the record if the same user needs to be able to unlock and lock records. You won't need the "full access privileges" setting if a different user with a different privilege set is the one allowed to unlock a locked record.
Feel free to reply back for more info if you can't figure out how to put this into a privilege set.
philmodjunk wrote: Did you notice that the OP has FileMaker 8.5? Might make it difficult to ope a .fmp12 file.
I noticed now
Retrieving data ...