auto populate information from another table

I have seen other users ask this question, but the responses all seem to be specific to their business (which is awesome customer service BTW), but I cant figure out how to translate it to my business...