Listing additional locations in an inventory
I am a beginner to Filemaker Pro and need help. I have an inventory database. It tracks the contents of 17 racks, each rack has 11 boxes, each box has multiple samples. I am trying to create a calculated field that will tell me where the same item is stored in all racks, boxes.
Example. Item A is stored in Rack 1 Box 1, Rack 3 Box 2 and Rack 4 Box 4. When I pull up the record for Item A in Rack 1 Box 1, I want this new field to tell me that Item A is also in Rack 3 Box 2 and Rack 4 Box 4. Is this possible for Filemaker? Please help if you can.