Linking tables

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.
 
G

Golfinray

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

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?
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query results for records that do not have selected value 2
Display information from other tables 1
appending new records to a table with a compound primary key 9
Design advice - changing data not bound to a form 2
Linking a Form to another Form Problem 1
Autocreate records from continuous form 1
One table too many! 10
Create a web site link from a part link and a data field in access 2003 1

Top