AnsweredAssumed Answered

Newbie Questions...

Question asked by edenforge on Aug 29, 2012
Latest reply on Aug 30, 2012 by edenforge

Hi folks

I'm got the trial version of FilemakerPRO 12 and have dowloaded the Starter Solutions/Inventory program.

 

As I'm wanting to make a simple Stock Control/Inventory system to keep details of Stock Items, Stock In, Stock Out, Stock On Hand, Cost Price and Sell Price, this looks as though it could be modified to do what I want.

 

The problem I cannot find a way to access the underlying tables, it would appear, from the code below, that there is a linked table called "Stock Transactions",

BUT where is it? and how do I get to see it?

 

[CODE]

If ( IsEmpty ( Sum ( Stock Transactions::Units In ) - Sum ( Stock Transactions::Units Out ) ) ; 0 ; Sum ( Stock Transactions::Units In ) - Sum ( Stock Transactions::Units Out ) )

[CODE]

 

The code is from the "units on hand" field in the Inventory table view.

 

Hope someone can help with this.

Regards

Bob

Outcomes