How to Duplicate records?

[back2basic]

You all have been a great help and I Thank you but now I am not sure how to proceed. Please offer advice and perhaps code statements to help.

Please allow me to explain: I have a parent table with two child relationships as follows:

Parent: Material_Assigment
Child: Materials
Child: Employees

The Parent table Material_Assignment uses a form (frmAssign_Materials) with two Combo Boxes (cboMaterials_ID and cboEmployees_ID) to select and create records of....of course assigned materials.

This all works great but my problem is when employees return the materials.I need or want to duplicate a selected record from the Material_Assigment table (Which includes the Materials_ID(PK) pertinent information and the Employee_ID(PK) pertinent information and edit it to insert the Return_Date and Quantity_Returned information. Since, obviously I can't edit and should not edit the existing record. I Have tried by creating a second form "frmreturn_materials with a Combo Box which shows all the materials assigned. It looks great but when I select a record, I cannot retrieve the data because the record is bound by it's auto number field Asset_ID. I mean, how else can I setup a query to record materials out and materials in? I hope I am on the right track and thank you for any help I can get.

Dale

 

[CJ_London]

I helped someone else recently with a similar problem.

See post #14 on this link for a sample db

http://www.access-programmers.co.uk/forums/showthread.php?p=1247390#post1247390

 

[back2basic]

Wow! Your code is precise. Still trying to follow it. Sorry but still not quite sure how to do this. Can I copy the entire contents of a record listed from an unbound Combo Box? If so, what would be the index for that new record so I can update the fields.

 

[CJ_London]

I would first look at the table structure and compare with your own

As described by you, Employee is the equivalent to your MaterialAssigment, and products equivalent to your Materials and Employees - which isn't perhaps the best way to look at it!

I'm suggesting you consider changing the way you look at your data to one more in line with my sample

 

[back2basic]

I would first look at the table structure and compare with your own

As described by you, Employee is the equivalent to your MaterialAssigment, and products equivalent to your Materials and Employees - which isn't perhaps the best way to look at it!

I'm suggesting you consider changing the way you look at your data to one more in line with my sample

Okay, I'll give it a good look tonight. One simple question, I see no relationships between the table. Is this because of the access 2010 conversion? Thank you.

 

[CJ_London]

shouldn't be - the benefit of documenting relationships is to provide a structure - they don't in themselves improve performance.

 

[back2basic]

CJ, simple and effective, Nice! What more could you ask for. This has helped a lot thank you.