If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
many to many relationships in msaccess
I have two tables, one called Country with one field, country ID (e.g.
Philippines), the other called Province with several fields, but the primary key is ProvinceID (e.g FIS which stands for South Philippines). But a country can have two provinces, e.g. Philippines has FIS and also FIN (Philippines North). And a Province may look after more than one country - part of its own, then an additional country (e.g. FIS looks after South Philippines but also Pakistan. Is this a many to many relationship? I think so, Why, then, am I getting a one-to one every time when I do thus: I create a third link table with the two primary keys (CountryID and Province ID, both text fields. I make them primary keys in a new table called provcountry. But when I drag provinceID to it counterpart in provcountry I get one-to-one. Same on the other side for countryID. WHY? |
#2
|
|||
|
|||
Please don't post the same item multiple times, in multiple groups. (see
newsgroup netiquette for further description) Jeff Boyce Access MVP "Volpe" wrote in message ... I have two tables, one called Country with one field, country ID (e.g. Philippines), the other called Province with several fields, but the primary key is ProvinceID (e.g FIS which stands for South Philippines). But a country can have two provinces, e.g. Philippines has FIS and also FIN (Philippines North). And a Province may look after more than one country - part of its own, then an additional country (e.g. FIS looks after South Philippines but also Pakistan. Is this a many to many relationship? I think so, Why, then, am I getting a one-to one every time when I do thus: I create a third link table with the two primary keys (CountryID and Province ID, both text fields. I make them primary keys in a new table called provcountry. But when I drag provinceID to it counterpart in provcountry I get one-to-one. Same on the other side for countryID. WHY? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 06:03 AM |
Deleting Relationships... | Kojones | General Discussion | 3 | December 18th, 2004 12:46 AM |
Relationships getting redefined? | raylitalo | General Discussion | 3 | December 15th, 2004 09:31 PM |
Saving Relationships | Leon | Database Design | 2 | November 2nd, 2004 11:41 AM |
Not seeing all relationships in layout window | jettabug | General Discussion | 3 | June 18th, 2004 05:42 PM |