Adding multiple info into one cell from a combo/list box

[Rhian]

I am trying to put together a consultant database which basically stores all
the information about our consultant including, countried they have worked in
and skills they have.

As you can imagine, the majority of the them have more than one skill and
have worked in more than one country and so I was wondering how I would input
all the countries worked in, into one cell space.

Would I do this by creating another table? If so how I would i creat the
relationship?

As you can read im pretty clueless so I would be grateful for any
suggestions and help in the simplest terms possible.

 

[xRoachx]

Hi Rhian--Based on your description, you need something similar to the
following:

-- Consultant Table
--- ConID: PK

-- Skills Table
--- SkillID: PK

-- Countries Table
---CountryID: PK

Since a consultant can have multiple skills and a skill can have multiple
consultants, you end up with a many to many relationship, hence the need for
a third table. A similar table is needed for the countries.

-- ConsultantSkills Table
---ConSkiID: PK
---ConID: FK
---SkillsID: FK

You would then use queries to display the information correctly. I hope
this gets you on the right path...

 

[BDW]

How this is so difference form all the other when you can control from your
reply really!

-
***************ou
******************************************************************
*
* Log opened: 2005-11-19T23:40:16Z
*
*
* About this log file - MSNMsgr.txt
* MSN Messenger 7.5.0311
*
* This log file is created on your computer when the Connection Logging
* setting is selected in the Options dialog box. You can turn off this
* setting at any time. To turn off this setting, click the Tools menu, and
then
* click Options. In the Connection section, click the Advanced Settings
button.
Under MSN Messenger Settings, clear the logging check box, and
* then click OK.
*
* The only way for MSN to get this file is for you to send it to us. If you
are
* having problems connecting to the .NET Messenger service and would like to
* report the problem to us, copy and paste this URL:
* http://support.msn.com/contactus.aspx?productkey=messenger
* into Internet Explorer. Fill out Sections 1 and 2 of the feedback form,
* remembering to copy the contents of this log file into the Details box in
* Section 2, and click 'Submit'.
*
* Caution: This file may contain personal information. Anyone with access to
* your Windows desktop can see the contents of this file.
*
*********************************************************************************
2PSessionRegistrar::RegisterHandler@01229BF8: registering
{5D3E02AB-6190-11D3-BBBB-00C04F795683}
[06:08:59.517] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {49389679-53DB-46A2-85D5-E3DAE9A0BCD5}
[06:08:59.517] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {4BD96FC0-AB17-4425-A14A-439185962DC8}
[06:08:59.517] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {1C9AA97E-9C05-4583-A3BD-908A196F1E92}
[06:08:59.517] P2PSession CAvatarEUF::Register returns 0x0
[06:08:59.517] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {5E288469-7693-4B64-A8DC-C56648E4397D}
*********************************************************************************
*
* Log opened: 2005-11-15T06:09:22Z
*
*********************************************************************************
[06:09:22.460] P2PTransport CP2PBridgeRegistrar::RegisterBridge@01229508:
registering TCPv1
[06:09:22.460] P2PTransport CP2PBridgeRegistrar::RegisterBridge@01229508:
registering TRUDPv1
[06:09:22.460] P2PTransport CP2PTransport::RegisterBridges: >> got
disallowed bridges ''
[06:09:22.510] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {A4268EEC-FEC5-49E5-95C3-F126696BDBF6}
[06:09:22.510] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {6A13AF9C-5308-4F35-923A-67E8DDA40C2F}
[06:09:22.510] P2PSession CP4EUF::Register returns 0x0
[06:09:22.510] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {5D3E02AB-6190-11D3-BBBB-00C04F795683}
[06:09:22.510] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {49389679-53DB-46A2-85D5-E3DAE9A0BCD5}
[06:09:22.510] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {4BD96FC0-AB17-4425-A14A-439185962DC8}
[06:09:22.510] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {1C9AA97E-9C05-4583-A3BD-908A196F1E92}
[06:09:22.510] P2PSession CAvatarEUF::Register returns 0x0
[06:09:22.510] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {5E288469-7693-4B64-A8DC-C56648E4397D}
*********************************************************************************
*
* Log opened: 2005-11-15T06:09:34Z
*
*********************************************************************************
[06:09:34.497] P2PTransport CP2PBridgeRegistrar::RegisterBridge@01229508:
registering TCPv1
[06:09:34.497] P2PTransport CP2PBridgeRegistrar::RegisterBridge@01229508:
registering TRUDPv1
[06:09:34.497] P2PTransport CP2PTransport::RegisterBridges: >> got
disallowed bridges ''
[06:09:34.547] P2PSession CP2PSessionRegistrar::RegisterHandler@01229BF8:
registering {A4268EEC-FEC5-49E5-95C3-F126696BDBF6}
[06:09:34.547] P2PSession CP2PSessionRegistrar::RegisterHandler

I am trying to put together a consultant database which basically stores
all
the information about our consultant including, countried they have worked
in
and skills they have.

As you can imagine, the majority of the them have more than one skill and
have worked in more than one country and so I was wondering how I would
input
all the countries worked in, into one cell space.

Would I do this by creating another table? If so how I would i creat the
relationship?

As you can read im pretty clueless so I would be grateful for any
suggestions and help in the simplest terms possible.

Upgrade your email with thousands of emoticons for free

 

[Rhian]

I think i understand. Im proberbly going to ask a really stupid question but
what do you mean by

PK and FK?

 

[Douglas J Steele]

Primary Key and Foreign Key respectively.

If that doesn't help you enough, you may want to read up on Relational
Database theory a little. Jeff Conrad has a good set of links at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101