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.

Outcomes