Yes... I understand and it worked. However, what I was trying to do is use the customer (recordID) as a "job number" because it's unique and auto generating number.
Would it be better if I created a new field in customer table and make that auto generate? if so, how?