I’m creating a Customer List so I want generate the custom id such that each customer gets unique id. Example, CC001, CC002, Thanks in advance

I made a table (Inventory) that consists of Barcode, Name and MRP. Some times the barcode remains the same only the MRP/Name changes. I gave like 2-3 data’s with same barcode, name but different MRP. In the Form Entry I referenced the column Barcode ...