Re: Inventory

One file with the multiple tables would work. The main file of
inventory could have a field for opening inventory. In a child-file
you could have the records of items sold (neg adjustments to inventory)
and the received items (pos adjustments to inventory). The child-file
could have calculation field summing the counts for each item, adding
to opening field to give a current on-hand.

A portal could show all transactions or be filtered for solds separate
from received.

.