I have 'Item' table with following fields,

Stock
Cost
Price
ReorderLevel
...

Whenever an item is sold, it deducts the quanity sold from the stock field. But in some special case two different records has to share the stock field, let us say Cigratee Pack and Cigratee Carton. Which ever item sells, stock has to reduced in both item rows. How could we do that

Another totally different question is how to maintain version for fdb file or is there any easy way to handle customer updates. Now I am using ibpump to pump data from old to new database, which is time consuming and error prone.

Any suggestions are highly appreciated

Thanks!

Muthu Annamalai