Assigning grouped attributes to a record

[owenik]

Hello everybody!



I'm a beginner in Access, and I have a problem.

I'm creating a database of companies. Every company has at least one field of services they provide.
There are three main groups which contain all the services (Let's say I have three tables).

What I need is to have a form/table (query?) where I can assign to a company any number of services from any group.
Is it possible to do it in a form where I could simply add a service by choosing a group first and then a proper service, and then add more in the same way?

I don't know if I explained it precisely enough, but I will be very grateful for any response.

Thank you in advance!

[June7]

Of course is possible. How depends on data structure. Sounds like a many-to-many relationship. Three tables would be required, like:

tblCompanies
CompanyID (primary key)
CompanyName

tblServices (all services for all groups in one table)
ServiceID (primary key)
ServiceName
ServiceGroupCategory

tblCompanyServices
CompanyID (foreign key)
ServiceID (foreign key)

[owenik]

Thank you for help!

So I have the tables made in a similar way.
Now, how exactly can I create a form to be able to assign a service to a company by choosing a group first and then one of the services included in the group? And after that to be able to add some more services that the company provides?

How could I make that work?

[June7]

Simplest way is a form with two multi-column comboboxes. Choose company from one combobox, choose service from other combobox. Check this tutorial http://datapigtechnologies.com/flash...combobox3.html

There are other tutorials at that site you may find of interest http://datapigtechnologies.com/AccessMain.htm