E
efandango
I want to create batch numbers for sets of records driven from a query.
I have a query that appends 10 records to a table, which becomes a
‘collection’ of 10 questions for a quiz.
Within the table is a generated autonumber [Point_Quiz_ID] which becomes the
ID tag for each question supplying the quiz form with the set of 10 questions
(records)
My problem is that I want to create another ID tag for the collection
itself. But this tag cannot be an incremental Autonumber; instead I want it
to be the same number in all 10 records. But which has the ‘unique’ aspect of
an Autonumber, whereby no two collections ever have the same ID tag number.
Does anyone know how I would resolve this type of problem?
I have a query that appends 10 records to a table, which becomes a
‘collection’ of 10 questions for a quiz.
Within the table is a generated autonumber [Point_Quiz_ID] which becomes the
ID tag for each question supplying the quiz form with the set of 10 questions
(records)
My problem is that I want to create another ID tag for the collection
itself. But this tag cannot be an incremental Autonumber; instead I want it
to be the same number in all 10 records. But which has the ‘unique’ aspect of
an Autonumber, whereby no two collections ever have the same ID tag number.
Does anyone know how I would resolve this type of problem?