Record Numbers

M

Michele

I have a Project Database that is working well. I have a separate Invoice Database that is not relational. It's time to make it relational to the Project Database (linking Project Numbers and Clients). I can do that, but here is my dilemma. We do the invoices every 4 weeks. There are on average about 80 invoices. Each period, I've had a separate table (this was before I learned about designing a database). So there were about 80 records in each "batch". This worked well, because we referenced the record number in the records of the individual invoices. Once I bring the invoicing over to the Project Database, it will be on one table, but each time a period is finished, the first invoice of the next "batch" will continue with the next record number. The people who handle the invoicing like having the 1-80 record number scheme. Is there any way we can use 1-80 record numbers? I know this is lengthy, but necessary to explain. Thanks for any help you can give me.

Michele
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA works in orignal but fails in copy of database 1
Copy previous record into form field 0
Adding detail to record in a table in a secondary table 1
Refresh data on each record 3
Part Autonumber 2
SQL Question - restated 3
Auto number in an existing table 4
Database design many to many relationships 4

Top