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
|
|||
|
|||
how do set up many to many relationships in Access
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 |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 10:04 AM |
Access 2003 (Ready to throw in the trash) | Patrick Parks | General Discussion | 5 | January 5th, 2005 10:38 PM |
WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
Need help with Access decision | aualias | General Discussion | 23 | June 21st, 2004 02:04 AM |