Linking tables

[MeSteve]

How do I go about updating records held in a linking table from a form? I
have a projects table and a contacts table with a linking table connecting
the two. To show the project manager, I want to update the linking table to
enter a particular contactID for the current projectID with a predetermined
RoleID.

 

[Golfinray]

Under tools/database utilities/linked table manager click the tables you want
to refresh.

 

[Klatuu]

It doesn't really matter where the table is. If you have a link established,
you can do anything you can with a local table. What is happening when you
attempt to update the linked table?

 

[MeSteve]

I am not connecting to external tables, so maybe linking table is the wrong
term. I have an intermediate table to make a many-to-many relationship.