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.