Assigning a field value to a seperate table

[Adam Charlton]

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.

 

[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]

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