SzymonHajduk

inventory menagment - How to show only some part of chart?

Discussion created by SzymonHajduk on Apr 16, 2016
Latest reply on Apr 16, 2016 by electon

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:

 

BALANCE TABLE:

Id

Generation_date

Product_fk

In

Out

Sum_of_in (running)

Sum_of_out (running)

Calculation (sum_of_in (running) - sum_of_out (running)) - When sorted by products give me idea how stock change

Sum_of_in

Sum_of_out

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.

Outcomes