Creating a Subform with a drop down list.

[Guest]

I want to create a subform that has a combo box with a drop down list from a
table of 8 Items.

Carpentry
Electronics
Computer
Gardening
Auto repair
Plumbing
Landscaping
Painting

In the subform I would like to be able to choose and store multiple items
for each record.
So far no luck.. I’m able to select 2 entries but not 3. I believe I have
to create another table to store these items, right?
Thanks much…………….

 

[Allen Browne]

Yes, you probably need 3 tables.

Skill table: One record for each skill (like your list.)
SkillID Text Primary key. Unique name for each skill.

Job table: One record for each job job to be done.
JobId AutoNumber primary key
ClientId Number who this job is for.
...

JobSkill table: One record record for each Skill needed in each job:
JobID Number relates to Job.JobID
SkillId Text relates to Skill.SkillID

Your main form will show information about the Job.
The continuous subform will be bound to JobSkill.
The subform will contain a combo that has Skill as its RowSource.

 

[Guest]

Thanks for your help Allen, I'll give it a try.

Yes, you probably need 3 tables.

Skill table: One record for each skill (like your list.)
SkillID Text Primary key. Unique name for each skill.

Job table: One record for each job job to be done.
JobId AutoNumber primary key
ClientId Number who this job is for.
...

JobSkill table: One record record for each Skill needed in each job:
JobID Number relates to Job.JobID
SkillId Text relates to Skill.SkillID

Your main form will show information about the Job.
The continuous subform will be bound to JobSkill.
The subform will contain a combo that has Skill as its RowSource.