data access page creation - fields cannot be updated

S

sb

Hi,

I have been stuck on this for a while. I have Access 2003 and am trying to create a DAP. The underlying record set is based on a join of three tables. I made sure that the UniqueTable entry for the DAP points to the appropriate table that can be updated.

Tbl Project:
ProjectId
ProjectName
...

Tbl Attribute :
AttributeID
AttributeName

Tbl ProjectData
ProjectDataID
ProjectID
AttributeID
State
Comment

Query :
SELECT attribute.AttributeName, ProjectData.ProjectDataID, ProjectData.State, ProjectData.Comment, attribute.AttributeID, project.ProjectID, attribute.Comment
FROM attribute, project INNER JOIN ProjectData ON project.ProjectID=ProjectData.ProjectID
WHERE (((attribute.AttributeID)=ProjectData.AttributeID) And ((ProjectData.ProjectID)=project.ProjectID) And ((project.ProjectName)=[What is the projectName ?]));

Have also set appropriate relnship and selected enforce referential integrity

DAP form contains AttributeName, State, Comment, ProjectID, AttributeID.
DAP property UniqueTable is set to ProjectData.

Still not able to update State and Comment fields using DAP. COuld do it thro forms when I set RecordSetType to Dyna..( Inconsistency..)

Any help is greatly appreciated.
Thanks,
sb
 
Top