Hello,

I have an "order" form with a lookup field "client" that select a client in a client form. The lookup field search the client by it's name an shows the name in the lookup field.

I also would like to pick the telephone and email in the "client" form and fill the "email" and "telephone" fields of the "order" table with it.

How can I do that ?