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