use data from one table to generate information in another table

G

G Stoner

I have created a receipts database to track receipts for multiple
departments. I am using a single form that you select a department from a
drop down list. After selection the receipt number is filled in with the
dept. initials and a sequential number from the dept. receipt table. The
result is then saved into a generic receipt table so it can be accesses for
reporting purposes.

Here is the problem:

When you select the department it brings up the next number and saves it
fine, but the number is not incrementing in the dept. receipt table. How do
I get the number to increment when my source table is the generic receipt
table.

I have to maintain different department tables for reporting and
individualized numbering.

Can anyone Please Help!!!!! I have been working on this for 2 weeks and my
deadline is in 2 days!!!!!!!!


Thanks!!!!!!!!!!!!!!
 
Top