AnsweredAssumed Answered

Constructing a description based on matching a field within one table

Question asked by SteveGruskin on Dec 26, 2013
Latest reply on Dec 26, 2013 by SteveGruskin

Title

Constructing a description based on matching a field within one table

Post

     I am working on an inventory system and would like to create a descriptive field made up of several other fields in the same table.  For instance, each piece of equipment is assigned to a case.  That case has a name and a bar code.  I can already easily list out the contents of each case by sorting by case name.  However, I would like to create a field that contains a description, made form a calculation of adding values from various other fields (manufacturer + item + model #), which would then be referenced when that case bar code is scanned.  The equipment sign out is tracked in another table that relates back to the inventory, so when a case is scanned, the case name comes up, but it would be nice to see a description of what is also in the case.  I can't figure out the calculation that will put together the description in the first table though.  Any advice will be well appreciated.

     I hope this makes sense.... Thank you!

Outcomes