multible insert

  • Thread starter Thread starter ddhung
  • Start date Start date
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
 
I may be missing something, but it seems to me, based on your table and
field names, that the Skill_Cate would be an attribute of the Skill, not the
Knowledge.

I don't understand enough about your data -- why would selecting a [S_level]
value result in a C_ID? Your tables don't show any relationship between
these.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
sorry, miss type there, basicly i want to insert two values (S_ID and
S_level) into the knowledge talbe by make one selection from a combo
box.
 
I don't see where, in your table structure, you have associated S_ID with
S_Level.

Without having these two somehow connected, you wouldn't be able to know
which S_Level went with with S_ID.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top