Populate a field based on another table result?

[Lee_Yanez]

Hello,

How do you populate a field based on another table result?

In Table1 I have my customer details.

In Table2 I have Installation details with the following – "Is the installation address the same as the customer’s address? – when the answer is “No”, an installation address is added.

When creating an ‘order’ (Table3) I can pull in my customer details (from Table1), but I’m having trouble adding the corresponding installation address (from Table2).

I’ve come at this from a variety of ways, but I’ve not been very successful. Any help is greatly appreciated – as always