A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

many to many relationships in msaccess



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2005, 02:53 PM
Volpe
external usenet poster
 
Posts: n/a
Default 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  
Old January 26th, 2005, 03:00 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.