Constructing a description based on matching a field within one table
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!