Single Field Lookup Auto-Populates Multiple Fields in Separate Table

[Spirit Journey]

Hello! Wow – the information provided by users on these forums is really impressive. I'm not new to FileMaker, but I am fairly new to using Relationships.

I have 2 databases: DB #1 contains contact information, including billing address field, a shipping addresses, as well as a branch number field for some, but not all of my contacts. DB #2 I am using to produce a packing slip using the contact data from DB #1 for shipments.

I currently have a Relationship setup between the 2 DB tables to separately Lookup the billing and/or shipping addresses for contacts that do not have a Branch Number; However, I was hoping that I could also use the Branch Number as a Lookup field in DB #2 to automatically auto-populate the necessary billing & shipping data from DB #1. In other words, entering a Branch Number in DB #2 automatically enters all the relevant shipping and billing address data from DB #1 into their respective fields.

Can anyone provide any advice on the best wat to get this setup?

Thanks in advance for your assistance!