I have a form that has a button the gets fired during an ON_CLICK event,
I want to do a SELECT of a table and get the MIN CUSTOMER_ID and store that value into a TXT field that appears on my form
What is happening is that my SQL is creating a table containing the MIN value.... this is not what i want
I want to save the MIN value into a TXT field on my form:
see the attached screen images
Can someone tell me the correct syntax of my SELECT statement?