I have create such a DB -> look at the end:
And I would like to have a 2 comboboxes in which I could select all
Prog_Id And Profile_Id and in this way modified datasource in each of
Rows in table Progs and aloso 6 textboxes to display and modified
datasource in each of rows in Profile_Base.
How it can be done in the fastest way ??
It is really urgent, beacuse i sit on it 3 days !!
Thanks in advance
-----------------------------------------
CREATE DOMAIN For_Prog_ID AS VARCHAR(20);
CREATE DOMAIN For_SubProgs As VARCHAR(20);
CREATE TABLE Profile_Base(
Profile_ID For_SubProgs NOT NULL PRIMARY KEY,
Param_1 FLOAT,
Param_2 FLOAT,
Param_3 FLOAT,
Param_4 FLOAT,
Param_5 FLOAT,
Param_6 FLOAT
);
CREATE TABLE Progs (
Prog_ID For_Prog_ID NOT NULL PRIMARY KEY,
Profile_S1 For_SubProgs,
Profile_S2 For_SubProgs,
Tenon_S1_S1 For_SubProgs,
Tenon_S1_S2 For_SubProgs,
Tenon_S2_S1 For_SubProgs,
Tenon_S2_S2 For_SubProgs,
FOREIGN KEY (Profile_S1) REFERENCES Profile_Base (Profil_ID)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (Profile_S2) REFERENCES Profile_Base (Profil_ID)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (Tenon_S1_S1) REFERENCES Profile_Base (Profil_ID)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (Tenon_S1_S2) REFERENCES Profile_Base (Profil_ID)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (Tenon_S2_S1) REFERENCES Profile_Base (Profil_ID)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (Tenon_S1_S2) REFERENCES Profile_Base (Profil_ID)
ON UPDATE CASCADE
ON DELETE CASCADE
);
--------------------------------
*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*