In my FileMaker Pro database, when I put a restriction on a field I am entering, such as numeric only or maximum characters, I am loosing all records in my table if I ignore this restriction.
Example, phone number set for maximum of 10 characters. If I put 11 characters in that field I get a notice of the restriction. But if I ignore the restriction & click on the button to go to the table of records, all records are deleted.
What causes this & how to prevent it?