Re: Matrix

Chris,

Research CROSS JOINs...

Bill Anderson

On Wed, Sep 18, 2024 at 6:03 AM Chris Davis chrisd@actongate.co.uk wrote:

Before I start does anyone have any useful pointers in writing some code to generate a list of all possible product combinations based on a matrix of options

PRODUCT A PRODUCT B OPTION 1 Blue x x

Red x

OPTION 2 Long

x

Short x x

A - Blue - Short A - Long - Short

B - Blue - Long B - Blue - Short

Obviously the actual matrix has a lot more options etc.

TIA

Chris.

--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

---

[excessive quoting removed by server]