I need to be able to create records by entering a range.
This would be like having an ID# field and being able to create new record #s 100 - 150. Each row would have the same values that were entered in other fields on the form.
The wrench in all of this is that our ID#s follow the format of 000-0000 or 000-0000-0000 (obviously these are our internal Ids not the pkeys). So, for instance, we may want to enter numbers 050-0700 through 050-0850 OR 030-0200-0001 through 030-0200-0100.
Does this make sense?
I'm invisioning something that would separate the numbers - identify the last four numbers in the string - and then loop as many times as it takes to make the first number = the second number - each time inserting a row based on the data in the form. I may be way off. Thanks for your time.
Trent
This would be like having an ID# field and being able to create new record #s 100 - 150. Each row would have the same values that were entered in other fields on the form.
The wrench in all of this is that our ID#s follow the format of 000-0000 or 000-0000-0000 (obviously these are our internal Ids not the pkeys). So, for instance, we may want to enter numbers 050-0700 through 050-0850 OR 030-0200-0001 through 030-0200-0100.
Does this make sense?
I'm invisioning something that would separate the numbers - identify the last four numbers in the string - and then loop as many times as it takes to make the first number = the second number - each time inserting a row based on the data in the form. I may be way off. Thanks for your time.
Trent