Combining Product Codes on One Record

Discussion created by canoevalley on Aug 24, 2016
Latest reply on Aug 24, 2016 by Johan Hedman

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.