GoToRecord subform - duplicate FK

[adbie]

Thanks,

and is it difficult then to do that in my db? (To copy 6 subforms via 1 single button click)?

 

[John Big Booty]

It will all depend on the structure of your underlying tables.

If I get a chance during the day tomorrow, I'll see if I can make some adjustments to my sample DB for you.

 

[adbie]

It will all depend on the structure of your underlying tables.

If I get a chance during the day tomorrow, I'll see if I can make some adjustments to my sample DB for you.

It would be amazing if you can make some time to take a look at my db.

I try to give a better description for the functionality:
Please take a look at the table tblBatch, there are 3 records include where the form productselection is based on.
Every Batchnumber has several foreign keys ( table tblProductino, tblPhysic, tblChem, tblMicrob, tblProductS, tblStorageC) that contain specific information (parameters) for that batchnumber.
Now I like to have a function (via a button?) that copy 1 record to a new one (tblBatch), all the productinfo that is linked to that batch (via Batchid)....

So when you press the copy button on the frmproductselection you see everything same, but as copy (batchid +1 in tblBatch, tblProductinfo, ....)

 

[John Big Booty]

I've added an additional button to the form, you can now duplicate the selected entry in the same master record, or append it to any other record.