Add support for entering a range for bulk carry forward

[grantfitzsimmons]

This issue outlines the requirements for implementing the series data entry functionality for collection objects (CO). The proposed feature is essential for users like the Louisiana State Arthropod Museum and KU Entomology, who require the ability to specify a range of catalog numbers during the carry forward process. Catalog numbers are allocated to particular groups/individuals for specific projects, and that means they cannot reliably or increment off the last highest catalog number in the collection.

Requirements

1. Entering a Range

   • Users must be able to enter a range next to bulk carry forward (e.g., from 100 to 200) instead of just incrementing from the last highest catalog number.

2. Validation of Catalog Numbers

   • Before proceeding with the bulk carry forward, the system must validate that the specified range of catalog numbers does not already exist in the database.
   • If the validation fails (e.g., if catalog numbers Catalog Number Formatter #1 to SubForm Button  #3 and Printing Support (Reports and Labels)  #6 to Search Dialog (from QCBX)  #7 already exist), the system must throw an error message:
     • "Catalog # in this range already exists."
   • This validation must act as a blocker for the save operation.

3. Proceeding with Bulk Carry Forward

   • If the validation passes for the first catalog object, the system must proceed with the bulk carry forward for the specified series.

4. Record Set Creation

   • Upon successful completion of the carry forward process, the system must automatically create a record set named "Batch {first catalog #} - {last catalog #}".

Non-Functional Requirements

• The system must ensure that the validation process is efficient and does not significantly delay the user experience.
• Error messages must be clear and user-friendly to facilitate understanding and corrective actions by users.

**Requested By:**KU Entomology and Louisiana State Arthropod Museum

Discussed in #5969

^{Originally posted by grantfitzsimmons July 16, 2024}
From #545 (comment)

• Create CO.
• Click Carry forward button
• Set carry forward to the desired configuration.
• Enter the range of bulk carry amount.
• Click the "Save" button. This will carry forward the CO data while incrementing the catalog number within the range and save them.
  ( no need with new implementation - Before the bulk carry forward, the system will check if the category numbers already exist. For example, if COs with # 1 to # 3 and # 6 to # 7 exist, attempting to create a new CO starting at # 4 with a request for 4 carry forwards will throw an error: "Cat # in this range already exists." This validation is one of the save blockers.)
• If the validation passes on the first collection object, the system will proceed with the bulk carry forward for the specified series.
• Automatically, a record set named "Batch {first cat #} - {last cat #}" will be created when this process is completed.

Being able to enter a range is important to some users, such as the Louisiana State Arthropod Museum:

They ONLY number specimens before they go into the database, so there's no such thing as adding a number that doesn't exist. This means that they need to be able to enter a range (e.g. go from 100 to 200) rather than just incrementing from the last highest.