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.