Generating sequential records

Gkirkup

Registered User.
Local time
Today, 11:30
Joined
Mar 6, 2007
Messages
628
I have a form on which there are two controls, first label number and last label number. Say these values are 1000 and 3000. Then a button which will create a record for each label between these two values.
How do I create a sequential list of records like this, each with a label number (and some other data from the form, which I will add.)

Robert
 
This seems like an unusual approach to working with data. Can you say more about what you are trying to do beyond creating sequential records? Once you have them, what will you do with them?
Maybe there's an easier way.
Cheers,
Mark
 
Mark:
There are many thousands of circuit boards, each with a numeric label. We already have tables with dates in stock of these boards, date of testing and sometimes date of repair etc. All that is long established and cannot be changed. I am adding a new table with the name of the tech who is given a range of labels. So if a tech has labels 3000 to 5000, he would use those on his boards. So I think I need a record for each label, label number and tech name. Then when we look at a form with details of the board, we can see the tech name for that board.
This seems to be the obvious way to do it - have a record for each label/board, with the tech name. So how do I create 2,000 sequential records?
One alternative would be to create labels for the whole label universe, and then apply tech names to certain ranges. But that seems almost the same.
Robert
 
So do you already have a record of each board and each board already has a unique identifier?

What I don't get is let's say a tech gets these newly minted labels and uses them. How does that data get back to a table so you can make use of it? You have a unique tech with a newly minted label number and he sticks it on a board. OK. What board did he stick label 3057 on? If you don't know that then what is the purpose of the exercise?

So I don't see how it's just a matter of sticking numbers on boards. You need to propagate data back from the tech in respect to a specific board on a specific date, and the board already has a unique ID, and the tech already has a unique ID, and date/time data is practically unique. So where does this new number fit into this reality? What is the unique object that gets this number? See what I'm getting at?
 
That's OK. I completed it by calling an append query in a loop, advancing the number in a control on the form for each loop. It works perfectly.

Robert
 

Users who are viewing this thread

Back
Top Bottom