I have a COMPANIES Table with a ONE/Many join to LOCATIONS Table with a ONE/Many join to LOCATIONCONTACTS and a ONE/Many join to LOCATIONADDRESSES;
and a CONTACTS Table with a ONE/Many join to LOCATIONCONTACTS Table

I want to produce an updateable query with the following information
CompanyName
ContactName
Address
City
State
Zip

ETC normal contact stuff.

If I add the companiestable, the locationstable, the locationcontactstable, and the contacts table...
the query is fine, and updateable,
when i try to include the locationaddress table...the dynaset is correct, just not updateable.
HELP

i try to do query in data access but it doesn't work. I have this number W14-1023-01 this is wrong right number is W14-1023-1 i can't replace because i have bunch of number like this W14-0145-1 please advise

i try to do query in data access but it doesn't work. I have this number W14-1023-01 this is wrong right number is W14-1023-1 i can't replace because i have bunch of number like this W14-0145-1 please advise

Victoria,

Which table do you want to update ? A new table or one that you have already specified? Also can you tell what error is thrown to indicate that the dynaset is not updateable?