D
ddhung
say i have three tables, "knowledge", "Skill" & "Skill_Cate"
in table Knowledge, there are K_ID, S_ID, C_ID, S_level
in table Skill, there are S_ID, S_NAME
in table Skill_Cate, there are C_ID, C_NAME
i have a form, there is a drop down list of number 0 to 4 represent
S_level, and the control source of the drop down list is point to
[Knowledge]![S_level] only, so after i select the level value it only
store S_level to Knowledge table.
Question is how can i insert a S_level and a dafult C_ID value into
both fileds in Knowledge table by one selection from drop down list. Is
there anyway i can hardcode my SQL query?
Thanks
in table Knowledge, there are K_ID, S_ID, C_ID, S_level
in table Skill, there are S_ID, S_NAME
in table Skill_Cate, there are C_ID, C_NAME
i have a form, there is a drop down list of number 0 to 4 represent
S_level, and the control source of the drop down list is point to
[Knowledge]![S_level] only, so after i select the level value it only
store S_level to Knowledge table.
Question is how can i insert a S_level and a dafult C_ID value into
both fileds in Knowledge table by one selection from drop down list. Is
there anyway i can hardcode my SQL query?
Thanks