Linked Tables- Form Based on query

[Ben Pelech]

Hello,

I have linked two databases with different information. The main database
is used to store call data (reasons for calls) and the other database is to
only pull certain calls and then review or audit them.

The table being linked pulls all the data. Then I have a query built to
only pull certain calls and then a form that pulls that information and has
additional fields to update. Everything works fine, except some of the
fields that are on the form (from the query) I also need to retain in the
other table.

For example:

Query has field for loan number, Reps name, date of the call, and manager
name. This information displays on the form based on the query, but I cannot
get it to somehow link into the other table. I need the loan number, reps
name, date of the call, and manager name, that were pulled from the other
database, to also be inputted into the second database.

Im sorry if this is not making sense. Any help would be greatly appreciated.

Thanks

Ben

 

[Golfinray]

Try file/get external data/link tables. Link the tables or queries of the one
database to the other.

 

[Ben Pelech]

Hello,

The databases are already linked. I can pull reports and have queries set
up. But I need some of the data in the linked database to fill in the tables
in the database. Basically, I have a form setup by a query that pulls data
from the linked database. I need some of this data that is pulled up on the
form, to fill in the tables.

Its kind of hard to write what I am trying to say.

Thanks