Thanks for the explanation!! As soon as I get the time I will try to work through it and see if I can get it to work. I am really excited about learning to do this. THANKS!!!
I build databases and websites but have never linked the two. I handcoded websites until a few months back when I broke down and bought Dreamweaver. I have a business that I built both a website and a database for and would like to link them together so when a customer completes a form on the...
The boss wants to keep the customer number limited to three digits and some customers have had the same number for years and dont want to change. So I have been given the task of finding a way to use the "holes".
JigJag,
Your SQL seems simple enough but I cant see how it returns a...
I have a table that has customer numbers that are manually entered from a form. The numbers are not sequential (in other words there are holes). On the form I want to display the next available unused number. So if the numbers already used are 1, 2, 3, 6, then I want to recommend the user to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.