Ok, help me before I flip out. Ple

[UrbaneRove]

Ok, help me before I flip out. Please

I have three tables

1 - Dealers - Master
2 - Addresses
3 - Representative

Relationships.

A dealer can have many Addresses
A dealer can have many Reps
A Rep can only be assigned to one Dealer
A Rep can not be assigned to a Address
An Addy can only be assigned to one Dealer
An Addy can not be assigned to a Rep

Dealer has unique key
Address and Rep have linkto keys both going to the Dealer unique ID number.

When I join two in a query everything is fine. When I join all three the recordset is not updateable. What gives.

Any Ideas

Thanks.

U.R.

 

[WildHare]

A One-to-Two-Many's is One Many Too Many...you won't have an updateable recordset.

Not sure of the exact reason why. I just set up a similar db and tried all join types, and JET steadfastly refused to allow me to make an edit on ANY field.

Sorry.

Jim







Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm