Hi
I am currently writing a database to control rental income. I have 5 sites all linked by a unique location ID number. All sites raise invoices and receive payments.
I have seperate controling tables for invoice numbers and receipt numbers with 3 fields 1) Key field ID 2) location 3) sequential number increment
How by making a one line entry (ie location and first number of range) can I replicate the location but sequentially increment the number a determined number of times?
The idea is that i can produce a table that can be easily updated when I issue a new range of invoice numbers or numbered receipt books to a particular site.
Hope this reads ok
Cheers
Graham
I am currently writing a database to control rental income. I have 5 sites all linked by a unique location ID number. All sites raise invoices and receive payments.
I have seperate controling tables for invoice numbers and receipt numbers with 3 fields 1) Key field ID 2) location 3) sequential number increment
How by making a one line entry (ie location and first number of range) can I replicate the location but sequentially increment the number a determined number of times?
The idea is that i can produce a table that can be easily updated when I issue a new range of invoice numbers or numbered receipt books to a particular site.
Hope this reads ok
Cheers
Graham
