Lars Heise Korsgaard wrote:
In stead I am thinking of creating a separate file for all the container data (either one per client or one for all clients ), so that I can leave this on the server when doing my update.
This is considered a best practice. Keep the container file simple, and you will rarely if ever have to mess with it.
I don't really think you would need a separate container file for each customer. Just the one should suffice.
.... I rarely write questions - you always seem to answer mine :-)
So if I continue this way
I would have one file with at least 3 fields.
a serial no. of the solution
( the last two for the relation)
I would then go for open storage - with a relative path of the clients serial no.
( each client has its own folder )
The file opens hidden with a user whose credentials can only add records (no admin of course)
Does this sound OK ?
I generally like secure storage, but yes, that's how I do it.