Hi,
I have a submission form that will register my customers and it needs to assign each customer to a group (example, Group 1- Group 5) with a hidden field. The customer needs to be auto-assigned to the correct customer group based on a field called 'Key-Code' which is correlates to the customer-group in the lookup table.
I am not sure the correct or best way to do what I am trying to do, but I assume it will require a lookup table, which I have created. The Customer Group ID LookUp Table has just two columns, the Key-Code field and the Customer Group ID field.
How can I apply