So all of a sudden filemaker has started creating duplicate records when I create a new record. The duplicate shows past payments, however nothing else other than the two records sharing the same ID number. I checked the scripts and everything is the same. Not sure what to do here any suggestions on how I might be able to figure out what is going on?
If you have filemaker pro advanced, just open up the Tools > Script Debugger, then try making a new record.
Chances are you have a script that is firing, duplicating the record. Or, you are incorrectly generating the primary key that relates to past payments.
Are you using UUIDs or serial numbers?