Example of list...

Type Number          Customer

33456                      Johnsons Wax

H512A                     Tim Hortons

I need a list with 150 type numbers with the corresponding customer.

When I select the Type Number I want the customer to be filled in automatically. (see atached jpg file)

Users do not normally know the customer for all Type Numbers.

How can I do this in EPDM ?