Help! Control unwanted duplicated records?

[christianv]

Hi everyone,

Sometimes some records in my FM database are duplicated. I tried to find why, and witch user was guilty, but I couldn't. So I'm wandering if there is any way to know witch script made a new record to be created? Like a flag or a control field that would tell me exactly what, when and who created each record...I know that there is a field that tells us the creator, creation date, modificator and modification date, but it's not enough I need to know the script that cause the record to be created...

Thank's a lot in advance!

[andygaunt]

Question,

How many scripts do you have that call the create new record command. How many databases are we talking about.

Your best bet if you want to know which script called the new record is to record that info from the script in a system field (say called Script caller, text field)

And in your script add a line;

Set Field [ Script Caller, "Enter your script name"]

HTH

[jasonwood]

I have encountered this problem a lot at my workplace. When you're working quickly it's really easy to hit Command-D when you mean to hit Command-F.

The hard way to deal with this is to disable the menus in FileMaker and operate the whole system from scripts. Sometimes that's essential and sometimes that's just a pain. You'll have to decide if it's worth it in your situation.

If only a small number of users need to create records, then you can prevent other users from doing it through permissions.