Copy multiple records (1 Viewer)

Hi all,

First of all I would like to tank everybody for their contributions on this site. They have been very helpfull to me.
At this point I've arived to not find any sollution on this or any other site for my issue.

I'm working on a database which has instructions for a production environment.
We have a product with a 10-digit code, which can be produced on different productionlines and whith differenent steps.

I've added a picture with what I have so far.
Left a form with a table with all product codes (10-digits), with next to it production version (A or B) and a line.
When chosen a code, you get to the form on the right. It titles you what you have chosen, with different steps (can be 1 to X steps), with the code of the instruction. When clicking on the code you'll get to a form with a detailed instruction.
These forms are linked to the table below.

The issue that I'm having is to create a copy button, which lets you copy the 1,2,..-steps to a new product code.
I've tried various ways but I always get stuck on only copying one step.
I've tried with duplicate record, tried to make a new form with unboud text field and paste the chosen data.
Does somebody know what to do?

Do you have a jpg of your tables and relationships?
If so, please post it.

We need more info about your environment and exactly WHAT you are trying to do in order to give meaningful advice/suggestions.

I don't get what other tabl you are looking for.
Both forms are based on the table on the JPG.

Left form is on a query without IFSQNR and IFFILLC (and "grouped by" to filter the duplicates).
Right form is based on the table aswell.

What I would like to happen when pressed on the button in this examples is:
Copy both lines selected in the picture, the user can sellect a new 10-digit code.
As example: new code is ABCD 01 0001
In my table it will be:
ABCD 01 0001 A 12 10 X12HC3
ABCD 01 0001 A 12 15 X17FA8

I hope this helps?

I'm not following. It is a rare case that a relational database contains 1 table.
Suggest you read the following article and see if your design fits.
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452

There are more tables, but ther forms with the issue only used one table.

I've added 2 pictures with an additional form and more tables that are linked.
IFILLC is linked with ICIECD and IDIHLC

I hope this helps. i'll start to read your attachement.

I've gone thru your PDF. My database should fit.