combobox
Please I need information how to bind combobox to database:
*cmb - combobox
*txt - textbox
And I would like to have in one cmb all Profil_ID in second cmb all Prog_Id and when I choose first and second cmb in 6 txt I would like to retrive and be able to update Param_1,...,Param_6 ...
I couldn't do it for 2 days ... HELP me PLEASE
------database-------
CREATE DOMAIN For_Prog_ID AS VARCHAR(20);
CREATE DOMAIN For_SubProgs As VARCHAR(20);
CREATE TABLE Profile_Base(
Profil_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
);
-----end-----
|
