Tables and Relationships

[LadyDiss]

Hi all! Seems like my problems always deal with relationships!! Anyway, I am working on another project too, have a table with some client information, first name, last name, address, and zip. Well, got it to work based on the ZIP, it populates the protection class and territory # (this is a separate table with ZIP as the primary key) ... however, I also want to base on the protection class and territory # and if the construction is frame or masonry, populate a premium group field for me. I think it works in the query, however, it won't let me add any more records, says the recordset is not updateable. Also, can't add that to a form, since it won't let me update. I was using another table. What am I doing wrong?

 

[LadyDiss]

Well, it is possible that I don't have things set up the most efficient way? I am still in the learning mode ... here is what I have ... three tables ... one Client Tbl, one ZIP code Tbl and one Premium Group tbl.

 

[cogent1]

Please post the query, not just the tables involved in it...

 

[LadyDiss]

Here is what I have:
SELECT tblClient.ID, tblClient.[First Name], tblClient.[Last Name], tblClient.Construction, tblClient.ZIP, tblZIP.City, tblZIP.[Protection Class], tblZIP.Territory, tblPremiumGroup.[Premium Group]
FROM (tblZIP INNER JOIN tblClient ON tblZIP.[ZIP Code] = tblClient.ZIP) INNER JOIN tblPremiumGroup ON (tblPremiumGroup.Construction = tblClient.Construction) AND (tblZIP.[Protection Class] = tblPremiumGroup.[Protection class]) AND (tblZIP.Territory = tblPremiumGroup.Territory)
WITH OWNERACCESS OPTION;

 

[LadyDiss]

Ok, so now how do I figure out which one and how to fix it? Thanks!

 

[LadyDiss]

I created all the tables and should be able to edit any of them. I am the original creator of the database. Why would this be happening?

 

[LadyDiss]

I am getting the Syntax error in FROM clause

 

[LadyDiss]

And the record set is still not updateable. Any ideas?

 

[LadyDiss]

I had caught the extra paren, however, it is still not updateable.