>>>I was wondering the best way to keep the relation between records.
>>>
>>>Set Filter?
>>>Set Relation?
>>>Use the relation properties in the grid control?
>>>
>>
>>John
>>How about parameterised views and a requery of each view as the customer changes.
>
>Hi Caroline
>
>The customers using the software don't use UPS and I a bit worried about the database getting damaged if the power goes off etc. All the tables are free tables.
>
John
I use local databases with just the views in them and have not had problems, but if you where worried then you could take a copy of the view database from the server each time the app is started.