ID field from data in 2 other fields
I have a Vendors table which has contact info for my vendors. It includes company, address and phone information. I am trying to create a "Vendor ID" field which will assign the ID from the first letter of the company name, followed by the last 4 digits of the primary phone number.
Can anyone help?