AnsweredAssumed Answered

Many to Many Relationships

Question asked by dinora on Mar 11, 2009
Latest reply on Mar 16, 2009 by philmodjunk

Title

Many to Many Relationships

Post

I know this question has been posted but I am still not getting it. 

 

I need to link airports to cities, airports can serve many cities and cities can be served by many airports.

 

I have then created a joint table where I can assign an airport to a city

 

In summary

Country ---<Airport

Country---< City

 

Joint Table City to Airport

I have an AutoID for this table as well as the Airport and City

 

So I have linked City ID from the city table to City field on the join table one to many

 

But when I am trying to link the airport ID to the airport field on the join table it wants to do a Table occurrance and create a duplicate table.

 

Can you help as to why this is happening

 

Country

City

Airport

Joint City to Airport

 

These are my tables and ideally then I want to have a portal where I can assign airports from the city table

 

I have a value list that displays airports by country which means on the portal if I am in Buenos Aires it should only display those airports that belong to Argentina

 

Thanks 

 

 

 

 

 

 

Outcomes