How lookup field based on a field in another table

Hello 

I have three fields
Site survey
leads
install

I'm trying to get the field roof type from site survey to show in both commissions and install table  and have the customer name to bring in the data to show the lookup field data that is already in the tables i.e the customer field. I want to have the account name auto generate that way I'm not always having to pick it out of the dropdown box. Is there a way to do this??

------------------------------
BLAKE CARLSON
------------------------------