RyanAshton

Fetch data from related table

Discussion created by RyanAshton on Feb 17, 2016
Latest reply on Feb 17, 2016 by coherentkris

Hi guys,

 

I have an "Estimates" table.  The "To" field is related to a client list in a related table.

 

I want to select from the client table list and once selected, the "Tel" and "Email" fields are automatically populated and the data from all 3 fields it copied into the fields with the same name in the "Estimates" table.

 

How do I do that?

 

Screenshot 2016-02-17 19.17.04.png

Screenshot 2016-02-17 19.17.13.png

Screenshot 2016-02-17 19.17.27.png

Screenshot 2016-02-17 19.17.34.png

Screenshot 2016-02-17 19.21.43.png

Outcomes