Find and Collect matching records
How would I set this up:
1. I have multiple records representing similar but different product numbers: 1234/2, 1234/3, 1234/4, etc.
2. Each of these records shares a common photo: 1234.jpg
3. When the record for any one of these product numbers is being viewed (1234/2 for example), I want the other records (1234/3, 1234/4, etc...) to be "gathered" into my layout. In other words, into a field that says something like: These product numbers all share photo 1234.jpg