Seems to me that if you keep any transaction-dependent information for a specific stock, that information should be in a child table.

For example, it's rare that Intel stock will change from the symbol INTC. However, if I bought 10 shares at $80, then the date it was bought and the price will be, probably, unique. And when and if I sell it, that too will be at a price that is unique.

Does this answer the question?

>I plan to develop a stock control system.
>
>My problem is whether to
> keep Openning Qty in a Single Table eg. opnbal.dbf
> keep Stock Out Qty in different Table eg. StkOut.dbf
> keep Stock in Qty in a Table eg. StkIn.dbf
>
>Or to keep openning,out and in qty in single table?
>
>Which 1 is better design?