Two databases

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • colleen1980@gmail.com

    #1

    Two databases

    I have two databases database A, database B. Same in database A there
    are table ta, tb, tc and databse B there are multiple tables too. I
    need help how to i connect with Database B table from database A. I
    have a form in database A which i need to add some information from a
    table which reside in databse B.

    Thank You

  • Jeff L

    #2
    Re: Two databases

    Probably the easiest thing to do would be to link to the other
    database. Click File, Get External Data, Link Tables. Then you would
    navigate to where Database B is, double click it, and select the
    table(s) you want to link to.

    Hope that helps!


    colleen1980@gma il.com wrote:
    I have two databases database A, database B. Same in database A there
    are table ta, tb, tc and databse B there are multiple tables too. I
    need help how to i connect with Database B table from database A. I
    have a form in database A which i need to add some information from a
    table which reside in databse B.
    >
    Thank You

    Comment

    Working...