hello guys,
i have two tables
table1 = customers info
table2 = custom invoices table
each customer will have invoices starting number 1
customer1 invoice 1 - 2 - 3 - 4
customer2 invoice 1 - 2 - 3 - 4
so now i have too much invoices i want to add to the system
when i enter all the data i want to check any customer what isthe missing invoice if existed
for example i entered the customer1 old invoices
from 1 to 100 then i forget to enter 101 and i continue from 102
so i want to check all the missing invoices between the first and last number
thanks in advance
i have two tables
table1 = customers info
table2 = custom invoices table
each customer will have invoices starting number 1
customer1 invoice 1 - 2 - 3 - 4
customer2 invoice 1 - 2 - 3 - 4
so now i have too much invoices i want to add to the system
when i enter all the data i want to check any customer what isthe missing invoice if existed
for example i entered the customer1 old invoices
from 1 to 100 then i forget to enter 101 and i continue from 102
so i want to check all the missing invoices between the first and last number
thanks in advance