If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hybrid Autonumber tag for batches of records
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? |
Thread Tools | |
Display Modes | |
|
|