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
    Guest

    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
     
  2. Loading...


Share This Page