Product subcategories and related products

3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 18, 2013   (RSS)

By Jesus - September 17, 2013 - edited: September 17, 2013

Hello,

I've 3 product subcategories and I need to have 3 different tables (because of the urls, as they need to have specific urls for each subcategory). I'm looking to have a select box automatically created based on each subcategory so I can get a list from all 3 different tables related products.

I know this its possible, I just had a hard time figure it out. If any one can help me to the right direction... :) Thanks!

Jesus

By Jason - September 18, 2013

Hi Jesus,

That's an interesting problem.  Are you looking to create this drop down box inside the CMS?

There are ways of doing it, but I'm not sure if this will be the best approach for you.  The issue with having a dropdown box populated by 3 different tables, is that when you are displaying those selections on the front end of the site, you have no way of knowing from which of those 3 tables a given selection came from.  So if you needed to retrieve a record based on a selection, or output a custom URL, you wouldn't be able to.

An easier approach would be to have 3 different dropdown boxes, 1 for each table.  That way you can have a simple query to get the records, and will be able to easily retrieve related records if need be.

Hope this helps

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/