Preventing a user from editing/deleting a record created by another person
I have a student ordering database where all students use the same guest account using the FM GO app. I am finding that some students are entering the database layout and accidentally editing or deleting the last record appearing when the layout appears on open. This DB is only accessed via FM GO. I have tried Entering a formula for limiting access on a record-by-record basis but I'm not sure how this would work if all students use the same Guest FM account. I'm looking for another solution on how help prevent users from seeing the last record or preventing them from editing or deleting past records.