AnsweredAssumed Answered

Deleting a Preferences Table record

Question asked by StanMillar on Mar 13, 2013
Latest reply on Mar 14, 2013 by DrewTenenholz

Hi all


Looking for a best practices here.


Background: FileMaker Server 12

Access by FileMaker 12 clients on a mix of Mac and Windows, some local, some remote access.


I am going to create a preferences record for each user who logs into my system.


My main question revolves around tidy cleanup when a user (for example) loses connection to the host. At some of my clients' sites, this can happen several times a day because of the quality of their internet connection.


What I don't want is numerous records for the same user accumulating over a day. I know I can run a script to clean up at the end of the day, but this does not suit the use case.


My thoughts are that I could query the table when a user logs in and if a record already exists, use the data from that instead of creating a new record?


Any other suggestions.