Creating N-N MAtrix

Applications Search
#1

Hello, I?m 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.

#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/exemplos_en_us/form57/form57.php

Gerd

#4

Re: Creating N-N MAtrix

Sometimes I over think the questions :wink:

Regards,
Scott.

#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

#6

[QUOTE=aka;25374]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[/QUOTE]

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