2. PHPRunner General questions
  3. [SOLVED]  multiple relationship
This topic is locked
[SOLVED]

 multiple relationship

 		12/26/2007 6:17:52 AM
PHPRunner General questions
U
 uzu1302 author

Hello,

I have another technical question:
I have 2 tables: "fournisseur" - Field (id_num, id_nom) and "marque" - Field (ma_num, id_num, ma_marque)

In the project, master = primary key fournisseur = id_num, detail = foreign key = id_num

On the list-page "fournisseur", I have the list of the "marque", but on the list-page "marque" I have no list of the "fournisseur".

It is necessary to create the third table (relation) ?
Ex: a "fournisseur" represents "marque" (renault, peugeot...) when I selectionne a "marque" I shall want to see his "fournisseur".

Thank you for your help.
Sergey Kornilov admin 12/26/2007

You can setup both relationships in PHPRunner.

First, select marque and choose fournisseur as master table.

Then make fournisseur selected and choose marque as master table.
U
 		uzu1302 author 12/26/2007

Thank you for the answer,

I thought of making in this way, but I cannot select the fields of the table "fournissseur".

Structure of "fournisseur" id_num, id_nom, ....

Structure of the table "marque" ma_num, id_num, ma_marque,...

A "fournisseur" can have some "marque"

a "marque" can have some "fournisseur"

eg: fournisseur "toto" represents "Renault, Ferari, jeep ...

When we are in the Marque page how to show the distributors ?
Create a new table "relation" with 2 fields (id_num, ma_num) and after how can it be done?

it is my problem there

Thank

You can setup both relationships in PHPRunner.

First, select marque and choose fournisseur as master table.

Then make fournisseur selected and choose marque as master table.