I am relatively new to Access but have some minor ability with it and would like to get some assistance regarding numbering. The purpose of my database is to control project revisions. For example let us say you have dozens of technical volumes (projects) with more being added each month. For each volume, revisions come out fairly regularly. I want to track each revision by project and I want the authors of the revision to be able to use a simple form to add the relevant information of the revision. Additionally, I would like the revision number to automatically generate a sequential number per project ensuring the same number is not used twice or a sequential revision number skipped. If I use auto numbering I can achieve that goal for each individual project but would have to create a database for each project to accomplish this. It would be very cumbersome to have to create an individual database for each project, however if I do not do that, I can see no way to accomplish this goal. Please let me know of any ideas you may have to simplify this process. Thank you very much for any assistance.