Summary Field Data

Question

I have created a summary report that shows the number of records that I have for each item. I would like to take the number from the far right (the number of inventory items) and display on another table.

The closest I have gotten is having a report link to all the records of that particular item number. I don't care if that link works or not, I just need to be able to see the number of inventory I have.

------------------------------Katlyn Allen------------------------------

MarkShnierYou · Answer

Katlyn,Do you have a relationship where One Item Number has Many Inventory Records? If so, what you want to do is to make a summary field on that Relationship to total up the total qty or the total # of Inventory records and put that on your Item Number Master form.To make a Summary field you go into the relationship and use the link on the left side to Add Summary field.   ​​------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community