FMP 9 Pro won't add new records without overwriting old ones
Running 2 databases on FMP Pro 9 - one will allow new/duplicated records to be added. However, 2nd database of 65 mg with 12000 entries will delete an older entry arbitrarily and replace with new addition. So if I have 12000 entries and add a new one, total records still show as 12000 as one added and one deleted. Have tried recovering the file but still same problem.