MX Tree Menu Forum :: Two Tables

This thread was displayed: 73 times

Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/


View All View Non Threaded Newest first
  • 02-21-2007 09:13:21 GMT +2 CenturyPixel

    I just came accors a situation where I have the parent and the child categories are on different tables.  So I will need to do some sort of JOIN.

    tblParent -> pcat_id(PK), pcat_name
    tblSub -> scat_id(PK), scat_pid(FK), scat_name


    tblParent, pcat_id is autoincrement and is the IDs for Parent Categories.

    tblSub, scat_id is just autoincrement, scat_pid is Foreign Key to pcat_id.  I know I am going to have to manually edit or use the QuB3 or something, but I just cannot figure out the logic.  Your help with this would greatly be appreciated!


    Thanks in advance!

    • 02-21-2007 09:47:42 GMT +2 Razvan Racasanu [InterAKT]Adobe Systems Romania staff

      Hello,

      Unfortunately you cannot use 2 tables with MX Tree Menu, as it requires data to be in a single one.

      Regards,
      Razvan RACASANU

      • 02-21-2007 11:03:22 GMT +2 CenturyPixel
        That is what I thought. By th... View more

        That is what I thought.  By the way, is there any place where we can post our completely Interakt based web sites on this website to tell how great this product to other users? :-)


        Thank you Interakt again!

        • 03-01-2007 11:37:43 GMT +2 Razvan Racasanu [InterAKT]Adobe Systems Romania staff
          Hello, Thank you very much ... View more

          Hello,

          Thank you very much for you appreciation and wanting to post this publicly, but unfortunately that section of the site has been discontinued.

          Regards,
          Razvan RACASANU

© Adobe Systems Romania. All rights reserved.