Copying Records

[ncopeland]

Hi

I have a header table and a detail table. In the header table there is a part number this is linked to a part number field in the detail table. There a number of detail records per header record.

The user wants the ability to enter a part number and create a new record in the header table for a new part and duplicate all the records in the detail table that relate to the selected part.

Can anybody suggest a way of doing this. I will create a form with two fields. First field will be a combo box that relates to all records in the header table, the second field will be the new part number. I will then create a button that the user will click on to copy all the detail records that are equal to the part number in the header table and tag each of these records with the new part number.

KR

NC

 

[zevw]

I don't understand, if you want to create a new part what details are there to duplicate? this part was just created! please clarify!

 

[ncopeland]

Hi

The two tables in question are a route header table and route detail table. The route detail table relates to a part and has all the instructions required to create the part. Basically everything in this table that relates to a part needs to be duplicated to a part number which the user will enter. A lot of parts use the same process to create them and this is to save the user lots of time rekeying.

KR

NC.