AnsweredAssumed Answered

Grouping records with same field

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

Title

Grouping records with same field

Post

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...

Thanks!

Outcomes