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.