Hi I'm novice at filemaker,
I trying to build some simple inventory menagmet database.
Balance table where I count down inventory stock looks like that:
Calculation (sum_of_in (running) - sum_of_out (running)) - When sorted by products give me idea how stock change
Calculation(sum_of_in - sum_of_out) When sorted by product give me up-to-date stock
Now. When I'm in PRODUCT TABLE i want to show how stock change. Using relation between PRODUCT TABLE and BALANCE TABLE
Show Product_fk = Product_Pk
and extra because I want to see only changes of stock that was taken since some date. HOW TO DO THAT??
when I add extra filed to relational between PRODUCT TABLE and BALANCE TABLE I can see only part of records but Calculation also change and dosen't show real value.
Sorry for my english but outcorretion seems to not work.