Lookup value

[Matt Malyschko]

I have a script that acquires a value in a variable.

For example: $CustomerName = "Tom Smith"

I want to be able to retrieve the associated CustomerID from the Customers table once I have this value. Is there a way to do it without going to the layout, finding the record and the setting a new variable with the CustomerID? Can I use a lookup to do this? If so, how?

Cheers!