Puzzled by Relationship Window

[perrydaniel]

Hi,

I have a database that has a 1-M relationship, which is et up as follows.

Table1
OwnerId (Key)
Name

Table2
PropertyId (Key)
Owner

Any owner can have own more than one property, which is working fine, but everytime I add a new owner the relationship window shows Loads of links (One for each Owner) linked to Owner in Table2? I am puzzled as to why this might be happening? Probably a simple mistake but, not sure why. Please come to my rescue

 

[THWatson]

perrydaniel
I have often seen one additional table that Access created in the Relationship window. For example, one additional table on the "many" side and that additional table would have the same name but with "1" appended. I forget the reason for this...but there is a reason.

I have not seen "loads" of additional links.

Check these things...
1. Your OwnerId primary key in Table1 should be a foreign key in Table2. And that's where the one-to-many join should be. I'm not sure, from what you describe, whether or not that's where you have the join.
2. When you run a query, are the correct number of records returned?

Tom

 

[perrydaniel]

Tom, yes you have it right, Foreign Key in Table 2 and I am getting right amount of records

 

[willir]

You are suggesting that every time you add a record, the Relationship GUI tool will display another table with the link??? Weird.

Does your form create a relationship through code?

When you open the Relationship GUI window, do you add tables?

Anyway you could have created a loop with your relationships in your design?

Have you run Compact and Repair (from the menu, "Tools" -> "Database utilities")?

I am stumbling I know, but what you discribe is weird.
Richard