Announcement

Collapse
No announcement yet.

Creating N-N MAtrix

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating N-N MAtrix

    Hello, Im really new with Scriptcase and so i have a problem in how to use it rightly !
    My problem is:
    I have 3 tables
    Table1: field_id_prod (serial), production_line (text)
    Table2: field_id_cat (serial), category (text)
    XTable3:field_id_prod (int), field_id_cat (int), manpower(int)
    so i have to create a matrix to choose the manpower in dependent of the choosen fields from Table1 and 2.
    I tried to made a double select to organize the relationship between Table1 and 2 but my fields stay empty !

    Any ideas at the moment ?
    thx in advance

    Gerd

  • #2
    Re: Creating N-N MAtrix

    You might have better luck by creating a crosstab (pivot) table using mysql/php than trying this in SC directly. You can then display the new table/view as a grid in SC.

    google: mysql privot

    Regards,
    Scott.

    Comment


    • #3
      Re: Creating N-N MAtrix

      Hello Scott,

      is the beginning of creating the matrix not really the same as :
      http://www.scriptcase.net/systems/v5...m57/form57.php

      Gerd

      Comment


      • #4
        Re: Creating N-N MAtrix

        Sometimes I over think the questions

        Regards,
        Scott.

        Comment


        • #5
          I have a similar need. You link is dead. How did you resolve it ?
          At this moment I do not need to update so I only need a dB VIEW which will show data from two cross referrenced tables. Not sure how to create a view in SC

          Arthur
          -----------------------------------------
          Arthur Klisiewicz
          dATA POINT SOFTWARE
          www.datapointsoftware.com

          Comment


          • #6
            Originally posted by aka View Post
            I have a similar need. You link is dead. How did you resolve it ?
            At this moment I do not need to update so I only need a dB VIEW which will show data from two cross referrenced tables. Not sure how to create a view in SC

            Arthur
            You don't create a view in sc
            You create the view in the db and use sc to create the
            Grid to display the data

            Kev

            Comment

            Working...
            X