Look Up & Complete Fields

Look Up & Complete Fields

I have been trying to figure out how to use the lookup field where once the data is selected other fields from that database are also added. In other words, If I have part #, Part Name, desc & price.
If i lookup part number, all other fields for that part will show up with it.
Its probably right in front of my face but I cant find it.