[MS_AccessPros] Join / table issue - Can't edit data

 

I have 3 tables in my DB. Table A has Job header data (on record per
job). Table B has job process detail data (multiple records per job).
Table C has job status date information. These tables are joined by
job_number. When I write a query and join tables A and B (by
job_number), everything works fine. My data is displayed accurately,
and I can modify data as needed. When I add table C to the query
(joined by job_number), my data displays accurately, but I can no longer
modify any data through the query view. Any idea why I can't modify any
data (in table A, B, or C) in the query view when I add table C?

Thanks,

Troy Sherven

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___