Linking tables

  • Thread starter Thread starter MeSteve
  • Start date Start date
M

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.
 
Under tools/database utilities/linked table manager click the tables you want
to refresh.
 
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?
 
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.
 
Back
Top