Hello.
In my Database I have the following tables,
job,
labour,
material,
customers,
quote,
labourquote
materialquote,
I am going to copy and rename the job table to job08 and use this as the current job table.
All new jobs will be entered into this table and the Job_No will start its auto increment at 08000000.
Now, if we get a query from the previous job table how easy is it to add a dropdown box to the search field to select the different table?
Thanks
Paul.