Assigning a field value to a seperate table

  • Thread starter Thread starter Adam Charlton
  • Start date Start date
A

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.
 
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.
 
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
 
Back
Top