Database lookups and display in other fields, and display rules

[kueblaikhan]

Two questions

First I want my form to look up one field from a datasource and then display
two other fields in two tables below this. I have managed to created the
link to the first lookup box, which has a drop down list of the servers. The
problem is I can not make the two fields below it display the corresponding
location and customer.

Next, I want to have a to field populated based on the choices of a dropdown
box. I can not figure out a way to populate the new field based on choices
of the first box.