What is the best way to have a lookup that supports creating a new record if one isn't found?

[Dave]

Jack you are a genius!

Thank you very much , it worked like a charm!