I have let's say 1000 various part number configuration and prices. I would like to consolidate and select in particular maybe 30 products in 3 various configurations. So a very abbreviated list to be formatted in a form view. Such as Product A - with option 1, Product A with Option 2, Product A - with option 3. The product A to Z would be the 30 various hand pick parts that I would to create a price list from.
How do I do such a thing because a form view is typically only one record and I want to pick 30 x 3 so 90 records in a particular format/layout?