Why are records being deleted

Discussion created by sundown on Jun 26, 2018
Latest reply on Jun 28, 2018 by philmodjunk

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?