AnsweredAssumed Answered

Grouping records with same field

Question asked by Lonny on Feb 4, 2009
Latest reply on Feb 11, 2009 by Lonny


Grouping records with same field


I have a table listing all of our products. Each record is a product with fields "catalog n" (1,2,3...) and "variation code" (a,b,c...). The table listing all records therefore looks like this:

1 - a

1 - b

2 - a

2 - b

2 - c

3 - a


I would like to be able to filter the list of products so that only the different catalog numbers are shown (say in a portal), and clicking on each lists the available variations, something like this:


1 - a,b

2 - a,b,c

3 - a


Sorry for not being too clear, still learning FM...