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