Copy record

[johann201]

In this db i created a project call "room01", corresponded with 2 materials "Wood,Glass"and I gave marks TO THEM "cRETARION_1,cRETARION_2" in "E_values"Table.
After that i created a project call "room02", corresponded with 1 material "Wood"......

AND THE QUESTION IS:
HOW CAN I CREATE A FORM WHERE I'D LIKE TO GIVE MARKS TO Room2-->Wood like Room1-->Wood.In other words to copy "Cretarion 1 and 2" from the Room1-->Wood TO Room2-->Wood

Any Ideas...would it be gradefull...I'm noobie so plz help

Thanx In advance...Johann...

 

[johann201]

hi again

i find that query to the forum:

INSERT INTO e_values ( cretarion_01, cretarion_02 )
SELECT cretarion_01, cretarion_02
FROM e_values
WHERE Id_Evs.primaryKey=selectedItem.primaryKey;

But i can't compare it...to my db

Any ideas?