I have a large query that contains a number of skills.
It's designet with one table for employees, one for skills, and one for skillCombos. (so that an employee can have a number of skills, and a skill can be "known" to a number of employees).
The structure:
tblEmpl
-------
INI
Field1
Field2
Field3
tblSkillCombo
-------------
SkillComboID
SkillID (rel: tblSkill.SkillID)
INI (rel: tblEmpl.INI)
tblSkill
---------
SkillID
Field1
Field2
Field3
The model works great with the exception that it is a lot of work maintaining the data. I have a form that shows the employees in rows with the skillname as a column, marked with 1 or nothing.
To get the "1", you need to go inn to another form a register the skill on that employee. Usually the user register a skill to many employees at the same time, and it has with my old DB been done by checking boxes (all skills was checkboxes in tblUser in the old version).
Is there anyway I can "transform" the "1 and nothing" to a yes/no checkbox?, and how can I register data by checking the boxes?
It is not possible to write a "1", because the form based on the CrossQuery is locked for registering data.
I would appreciate any replies on this one.
Bes Regards, K.
It's designet with one table for employees, one for skills, and one for skillCombos. (so that an employee can have a number of skills, and a skill can be "known" to a number of employees).
The structure:
tblEmpl
-------
INI
Field1
Field2
Field3
tblSkillCombo
-------------
SkillComboID
SkillID (rel: tblSkill.SkillID)
INI (rel: tblEmpl.INI)
tblSkill
---------
SkillID
Field1
Field2
Field3
The model works great with the exception that it is a lot of work maintaining the data. I have a form that shows the employees in rows with the skillname as a column, marked with 1 or nothing.
To get the "1", you need to go inn to another form a register the skill on that employee. Usually the user register a skill to many employees at the same time, and it has with my old DB been done by checking boxes (all skills was checkboxes in tblUser in the old version).
Is there anyway I can "transform" the "1 and nothing" to a yes/no checkbox?, and how can I register data by checking the boxes?
It is not possible to write a "1", because the form based on the CrossQuery is locked for registering data.
I would appreciate any replies on this one.
Bes Regards, K.
