Recordset is not updateable ???

[harleyhead]

I have two tables: Sales Order Header and a Customer Master. It is defined as a one-to-many relationship(Customer to Sales Order). When I create a query based on the Sales Order Header, with the Customer ID from the Sales Order Header and include some items from the Customer Order Master (for display purposes), I get "recordset is not updateable". If there are no items from the Customer Master, the Sales Order Header is maintenable. I have followed Access 101 rules for the autofill feature. What am I missing?

 

[thornmastr]

Possibly because the relationship between Sales Order Header to the Customer Order Master is many to many?

If so, you might want to investigate a juncture table between the two. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[nberryman]

Make sure that you only have ONE primary key in the query. If you have two then it wont allow certain things

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[thornmastr]

Neil,

Would you mind elaborating on this a bit. Please.

“Make sure that you only have ONE primary key in the query. If you have two then it wont allow certain things”

Specifically, why would it matter if he has the primary keys from both tables included in his query as long as his join is properly constructed.

Thanks.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[nberryman]

OK, I am a Trainer and I have a lot of experience with new users.

A quite common error is to include more than one Primary key in a Query. Yes, if the joins where correct then this would not be an issue but, as inexperienced users the joins tend not to be correct and hence my advice

Regards

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[Rhonin]

Could you post the SQL string for this?

Rhonin
"too many questions, too little time..."