×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Referring to multiple fields throught different tables/db's properly

thread295-1362148

Referring to multiple fields throught different tables/db's properly

Referring to multiple fields throught different tables/db's properly

(OP)
Trying to manage inventory:
Need partno X qty to be properly effected by adding po's received qty, (logging backordered qty), alloacating (removing from inventory partno X qty) workorder amounts and when the corresponding invoice is made from the work order, removing the allocated amount in enventory at that time.
Right now I can track the rec'd amount to add to Stock Qty in inventory for one PO only, I need this to apply to any partno on any PO
Hope thats enough info for you.
Been a while since I've been on this forum (different user name) - it's never failed me yet !!

RE: Referring to multiple fields throught different tables/db's properly

(OP)
Perhaps a clearer explanation here:
Tracking quantities of a given part number to maintain inventory.
Trying to make inventory consolidations: databases that effect any given "part number's qty field" in inventory database are:

"PO's received field" in PO database(adds to "stock on hand field" qty in Inventory database),

"Backordered PO items field" in PO database(adds to "Stock BO'd field" in Inventory database),

"Work Orders Quantity field" (for any partno)in Work Orders database (removes from "stock on hand field" in Inventory database and puts into "allocated field in Inventory), invoiced work orders remove part # qty from "allocated field" in Inventory.

RE: Referring to multiple fields throught different tables/db's properly

(OP)
So far I can only update BO'd Qty (in inventory) for any given part number from the first occurance only in the PO BO'd field (doesnt matter if it is the first, second last, etc PO where the part number is, it only picks the first occurnace), how do I get it to "scan" all PO's for a BO for any given part number?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close