I have a two part question!
1. I have a database that tracks "coils" for a steel company. One the coil is all used up and the weight is "0" I want to be able to delete that coil from the data base so I don't end up with a 200 page report showing coils with a weight of "0". I know how to block the records from showing up on a report but I want to delete them so that I can reuse that coil number again in the future. What is the easiest way to do this.
2. I have the coil number to automatically generate the next coil number when a new record is entered. Is there a way to tell access to go back and find the coil numbers that are not accounted for (because they were deleted) and reassign that number to a new coil
I hope at least some of this made sense thanks for any help you can give me.
1. I have a database that tracks "coils" for a steel company. One the coil is all used up and the weight is "0" I want to be able to delete that coil from the data base so I don't end up with a 200 page report showing coils with a weight of "0". I know how to block the records from showing up on a report but I want to delete them so that I can reuse that coil number again in the future. What is the easiest way to do this.
2. I have the coil number to automatically generate the next coil number when a new record is entered. Is there a way to tell access to go back and find the coil numbers that are not accounted for (because they were deleted) and reassign that number to a new coil
I hope at least some of this made sense thanks for any help you can give me.