Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Copying Data Between Tables

Discussion in 'Information Technology' started by David M C, Jul 28, 2006.

  1. David M C

    David M C
    Expand Collapse

    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.


    WorkOrderID (pk)


    WorkOrderID (fk)
    OrderDetailsID (pk)


    WorkOrderID (fk)
    WOValuationID (pk)


  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page