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?