Linking two databases?

>I have a database where I would like to enter some data. This data
would fill a table in that database but it would also fill in a table
in another.
>
Is this possible to do?
>

>I have a database where I would like to enter some data. This data
would fill a table in that database but it would also fill in a table
in another.
>
Is this possible to do?
>
Do I need to have the same field names in each table for this to work?
>
What steps would I need to take in order to accomplish this?
>
I opened up the 2nd database and selected the "get external data"
command which allowed me to import an identical table as the one in
the first database and link them. I was able to do enter information
in one and have it show up in both databases but was unable to get
that information into an existing table in database 2 only the copied
identical one.
>
Any suggestions, i hope this is clear.
>
Thanks
>

As the other poster stated, there isn't a need to populate two database with
the same data. You can just link to the data in one from the other. But, if
for some reason you absolutely need to do it, just create a link to the
table to be populated in the database containing the data. Once a link is
created, you can populate the table and otherwise work with it as though it
were in that source database.
>
Neil
>
"Tyler" <t.sla...@utoronto.cawrote in message
>
news:1182259042.995506.30010@q69g2000hsb.googlegro ups.com...
>
>
>>>>>>>>
- Show quoted text -

On Jun 19, 10:51 am, "Neil" <nos...@nospam.netwrote:>
To clarify a bit, not all the information entered in the one database
is needed in the 2nd. Im not sure if that would make a difference or
not from the previous responses.
>