Quote Originally Posted by bigduffeye View Post
thanks gilby - i get what you are saying, but i really do need 50 different cross sell tables, each furniture set can only have items from its own specific set in the cross sell.
Yes and No!

The 2 examples shown use 2 different headers
"Ariel Bedroom Set" and "Cube Bedroom Set"
As they use different headers then yes you need 2 tables to do this
and if you are going to have 50 different headers then yes you will need 50 tables.

BUT if you were to use a more generic header for all of them
such as "Matching Bedroom Set"
You already have the name of the set further up the page displayed boldly
Then you would need ONLY one table to do them all

I still believe you don't quite understand that.
Each set would be isolated strictly to that set ONLY!!!
The sets do NOT get mixed up using one table.

If you were starting from scratch using one table
For the first set you would enter the following Id's into the cross sell
275,271,270,269,273,430,431
then click "insert"

For the second set you would enter the following Id's into the same cross sell
265,470,471,260,264,262,259
then click "insert"

You will now have the same as what you have but with the one same header for both.
You can do all 50 sets like this if you wish into the same one table.

btw: there will probably be a performance hit searching 50 tables at a time
imo: One table is far more efficient with the low number of items that you cross selling