Creating a Subform with a drop down list.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TBoe - 01 Jun 2005 21:41 GMT

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…………….

Reply to this Message

Allen Browne - 02 Jun 2005 03:44 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I want to create a subform that has a combo box with a drop down list from
>a
[quoted text clipped - 15 lines]
> to create another table to store these items, right?
> Thanks much......

Reply to this Message

TBoe - 02 Jun 2005 20:05 GMT

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

> Yes, you probably need 3 tables.
>
[quoted text clipped - 33 lines]
> > to create another table to store these items, right?
> > Thanks much......

Reply to this Message