I;m new to Zoho Creator and am working through my first application - I love it so far.

My question is as follows : 

I have a 3 level data structure :

Customer (standard customer information)

Utility Meter - Multiple meters per customer

Meter Readings - Multiple readings per Meter

I have created the form hierarchy and all works well.

I would like to have a Lookup on the Meter Readings form that shows the Customer Name from Customer Table.

I know there is no direct link - it's through the Utility Meter table. 

Can I implement this type of lookup and how ?

Thanks

Ian