i have 2 tables. i want to update one field in one table. the thing is that the 2 tables must be joined by 3 fields. (date of call, call# and call phone number), meaning that call# is exclusive only to the call phone number).

when i try to update, the field, i get a message that the"Operation must use an updateable query"

what am i doing wrong?

Look up updateable queries in help for ideas on what is causing the problem. Three common reasons come to mind:
1. Both tables need to have unique primary keys.
2. You need update permission for both tables.
3. The query may not include any aggregate functions such as Sum() or Max().