AnsweredAssumed Answered

Relationship Between Databases

Question asked by dbkali on May 30, 2018
Latest reply on May 30, 2018 by ThierryGuemboura

I need help setting a relationship between three databases.

DB-1, DB-2 and DB-3

 

DB-1 has no records, the database is new and empty.

 

DB-1, has only 5 fields and 4 of the fields needs to pull info from DB-2 and DB-3.

 

DB-1 - field 1 needs to be the initial search field for lookup and then the info from DB-2 and DB-3 needs to be pulled to fill fields 2 through 5.

 

DB-2 - info from fields 19 and 46 needs to be pulled to fill fields 2 and 4 in DB-1

 

DB-3 - info from fields 7 and 8 needs to be pulled to fill fields 3 and 5 in DB-1.

 

I know it seems simple but I can't seem to get the relationships to work. Any info would be greatly appreciated.

 

Best,

AK

Outcomes