Lookup

Hi everyone

I'm hoping that someone may be able to help us with this question.

We currently have a list of customers and a list of service codes. In a form we choose a customer name and then choose a service code for that customer. This may look like:

Name: John Smith
Service Code: 55P662

We have another form that uses the name, but different pieces of information. We want to be able to select the name of customer (John Smith) then it automatically show the service code entered in the other form.

Could someone please help with how this could be acheived?

Thank you.