>>>>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.

Caroline

The programs are run on standalone machines.

John