I have a database with many product records. I need to make price signs for the store shelf. (Shelf Talkers). I would like to display the product number on the signs. There are instances where I have the same T-Shirt style but each colour has a different product number (record). I would like those product numbers on only one of the signs. I do not want to print a sign for Green T-Shirt, Black T-Shirt and Blue T-Shirt etc.
Is there a way I can combine the three product numbers on only one of the records?
NOTE: There are about 300 products and most products do not need to be combined as stated above, only a handfull of products share the same style but have a few different features and colour choices.
Let me know if you need any more clarification to my question.
Thanks for your valuable feedback.