Question Create new record in separate table

[gnarpeggio]

Good morning,

I'm working on an application where a user would initiate a new batch number for a group of records in one table, but would send this new batch number to a parent table. This seems backwards and I'm not sure if it can be done.

Is there any solutions that could do this? Let me know if I need to elaborate on this.

Thanks!

 

[spikepl]

"Initiate" how exactly? What the user thinks he's doing with the user interface need not be reflected exactly by the internal mechanics

 

[plog]

Please provide a more specific understanding of what you are trying to do.

Are the structures of the parent and original tables the same? Would just grabbing the record id's from the initial set of records and putting them in a new table with a batch number be sufficient?

 

[gnarpeggio]

What I'm trying to do is create a new record in a separate table for each batch number.

For example, a user will enter 30 records under one batch number. I'm hoping that each time the user begins a batch with that number, it is recorded into another table prior to the first record of the batch being created. The table that receives the batch number is the Parent table in the relationship setup.

I don't know if Access can assign a number on the fly when you have to have the number existing in the parent table to make the relationship.

Does this make sense?

 

[plog]

Almost makes sense. What other information other than Batch number goes into this parent table?

Usually when you work with levels of data you work top down--suppose you wanted to make a database of business contacts with 3 levels--business, department and people. You would first create a business record then enter records into a department table which links to the business table, then you would create people's records which link to the department they are in.

From a theory standpoint, I think you want to first define/enter batches then enter the data underneath them. From a practical standpoint this is how Forms and their sub-forms work.