Welcome to SPN

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

Sign Up Now!

Assigning a field value to a seperate table

Discussion in 'Information Technology' started by Adam Charlton, Jul 28, 2006.

  1. Adam Charlton

    Adam Charlton
    Expand Collapse
    Guest

    In a previous post I requested more broad info on how to accomplish what I
    need to in my database. Maybe if someone can just point out to me how I
    might assign a value from one table to a line item from another table based
    upon criteria. Hopefully someone understands what Im getting at. The tables
    are linked by a PartNumberID, but I want to assign the shipper ticket number
    from a supplier in one table to the purchase order line item from another
    table.

    Thanks if you can help.
     
  2. Loading...


  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    You should not need to store that same data in two places.

    Join the two tables in a query on PartNumberID and make it an update query.
    Run.

    "Adam Charlton" wrote:

    > In a previous post I requested more broad info on how to accomplish what I
    > need to in my database. Maybe if someone can just point out to me how I
    > might assign a value from one table to a line item from another table based
    > upon criteria. Hopefully someone understands what Im getting at. The tables
    > are linked by a PartNumberID, but I want to assign the shipper ticket number
    > from a supplier in one table to the purchase order line item from another
    > table.
    >
    > Thanks if you can help.
    >
    >
    >
     
  4. Adam

    Adam
    Expand Collapse
    Guest

    Though they do share the same part number, one table is from a manifest, the
    other is from a purchase order, so they don't really link up. My actual
    goal is to find a way to link them properly. We assign a ticket number from
    the Manifest to the order line item from the purchase order. I just havn't
    figured out a way to do this in access.

    Lets say I have: [PartNumber] RM-1001, with a [LineID] auto assigned in one
    table
    In the other table I have: [TicketNumber] 999663 with a [LineID]auto
    assigned.
    both of these are actually the same part, with the ticket number being the
    physical bundle that the parts are placed. I want to "assign" a line item
    from my PurchaseOrders table to one of the [TicketNumber]s from the Tickets
    table.

    How would I do this? Maybe I don't understand what an update query is, but I
    don't see how to accomplish this.

    I have only been working in Access for about 3 weeks, and I'm teaching
    myself, so I appreciate the help and any direction that you might give me.
    If I seem to need things spelled out, that's the reason.

    Thanks again,

    Adam
    "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
    news:524960E1-2AE2-4544-8F4E-1F9741A9BDB1@microsoft.com...
    > You should not need to store that same data in two places.
    >
    > Join the two tables in a query on PartNumberID and make it an update
    > query.
    > Run.
    >
    > "Adam Charlton" wrote:
    >
    >> In a previous post I requested more broad info on how to accomplish what
    >> I
    >> need to in my database. Maybe if someone can just point out to me how I
    >> might assign a value from one table to a line item from another table
    >> based
    >> upon criteria. Hopefully someone understands what Im getting at. The
    >> tables
    >> are linked by a PartNumberID, but I want to assign the shipper ticket
    >> number
    >> from a supplier in one table to the purchase order line item from another
    >> table.
    >>
    >> Thanks if you can help.
    >>
    >>
    >>
     

Share This Page