Im new to making databases and using scripts and formulas.
I have made an inventory and have three views. The main view I want to show beg qty, iss qty, rec qty & end qty. My other views show what has been issued and received.on all items. Can I pull the Qty Issued & Qty Received from the other views to my main view and then add/subtract to get my ending balance?
Subject: Columns & Views
Dawn,
Views can display all or a subset of documents. Columns can display field contents, or a computation of field contents. So a column can display RecQty - ISSQty, or whatever other fields are in a document.
does that help?
raphael
Subject: RE: Columns & Views
Thank you!!!
Now I just have to figure out how to get my ending balance to add/subtract right on my form and I’ll be happy.