How can I do this sort of relationship?

[sansangtracao]

I have 3 tables: events, country and city. Several events can take place in a country and in different cities of that country. Question: What kind of relationship I can build here???
Thanks

 

[traingamer]

Not enough information.

Can a single event take place in more than one city (or country)?


Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[fneily]

Before you answer that question, you may want to read:
Fundamentals of Relational Database Design

http://r937.com/relational.html

 

[sansangtracao]

Hi traigamer, actually the event can take place only in one city of a country! I managed to put the events to a country but cannot link the cities to that country but the difficult part is that on the report the country is displayed well (with names in text) but the city always appears in number.
What the right relationship would be in thius situation?

 

[RivetHed]

You should lay out your tables like this:

CountryID Country
1 UK
2 USA
3 Italy
4 Wherever

CityID CountryID City
1 1 London
2 2 New York
3 1 Bristol

CourseID CityID Course
1 2 Course1
2 1 Course2
3 3 Course3

Then join the like ID fields in a query to create the data for your report countryid is joined to countryid and cityid is joined to cityid.

 

[sansangtracao]

Thanks