Copying data between tables

D

David M C

I have two tables, WorkOrder, and WorkOrderDetails. These detail the works to
be carried out by our operatives. I need to create a valuation from this.

All the information in WorkOrder can be used in the valuation, but the
information in WorkOrderDetails can (and usually will be) changed (some items
added, some removed).

I need to put a button on my form that copies the information from
WorkOrderDetails and puts it in WOValuationDetails. The table WorkOrder has a
one-to-many relationship with WorkOrderDetails. The same relationship exists
between WorkOrder and WOValuationDetails. I'm guessing I need to create an
append query, and run it on a button click.

WorkOrder:

WorkOrderID (pk)
......

WorkOrderDetails:

WorkOrderID (fk)
OrderDetailsID (pk)
....

WOValuationDetails:

WorkOrderID (fk)
WOValuationID (pk)


Thanks

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RecordSet of Form 5
Adding data to MS Access from csv file 0
Custom Autonumber in Append Query 1
Table Lookup Field - options relative to record 1
Can't join 3
Problem designing a form envolving many-to-many relationships 3
Check box creates a new record when clicked??? Huh??? 3
Is it possible with one recordset? 2

Top