Related attributes need to show in related entities

Hi Zoho, hi everyone,

I seem to be stuck at a juncture, can someone show me the way?!

Here's what I am trying to do: There are customer entities and there are Invoice entities. When creating an invoice Zoho expects, on the invoice creation screen, for an existing (or newly created) customer to be selected and associated with the invoice being created. So far so fine. But what I want is, in addition to the customer name, I also want the customer's Mailing Address (entered while creating the customer) to show up on the Invoice or better yet, I want the address to be AUTO filled in when I select the customer. How can I implement this? I have looked at Lookup field types by that does not seem to be the solution. What I am looking for is a functionality that is available in ZOHO Creator whereby the RELATED attributes could be shown on the related entitiy field. I know that this related stuff could be pulled in while PRINTING the invoice but how can I do tihs on screen?

Any help would be much appreciated.

Thanks,
Kenneth.