Even does not know if this forum is the suitable
I have sql table with "division" i have column " name division " and "code division" ok.
AND THIS DATA DISPLAY IN COMBOBOX.
Now User wont to add new company UNDER DIVISION "TRANSPORT" he is select in combobox value " TRANSPORT" AND CODE 1000 OK
NOW I NEED AUTOMATICLY TO GIVE NEW (show to user in textbox) CODE TO COMPANY for example 1000\1 because he chose transport division (code division 1000) but before i give the new code to new company i need to check if
not already company with identical code if not to take a last company with 1000\n and add 1 example 1000\n+1 and put the new company name with new code 1000\n+1 to some table in sql or acces.
IN THE END I NEED TO PUT INTO THE TABLE THIS VALUES
Diagram like this
I have code 1000 now I go in to sql table CUSTOM2 and seeks a company with code 1000\max_num after obtained
the company with the maximum code I adds to the code + 1(1000\max+1) and display the cod in new text box/
Request will help me very important matter for me.
View Complete Post