Create a REAL lookup field

Create a REAL lookup field

Is there a way to bring other information from a lookup field into a new record?  I have a form called Site where I record the information about a Site I service.  I also have a form called Work Order, where I find the Site in a Lookup Field that the Work Order is for.  When I use the lookup field in the Work Order it does me no good since it doesn't bring across any of the other information from the Site record.

Is there an easy way to get Zoho to carry other fields into a child form when you use a lookup field?  It seems like this should be simple, but it isn't.