1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Refreshing a Column Value in the Master Table

Discussion in 'MS Access' started by Rabi, May 19, 2008.

  1. Rabi

    Rabi New Member

    Joined:
    Mar 15, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    I have two tables - a MasterTable and a ChildTable - related by a field "PO_Number" (set as Primary key in the MasterTable)
    There is a column "PO_Status" in the MasterTable and its corresponding column "Status" in the ChildTable.

    I need to refresh a column in the MasterTable automatically, as below:

    For a particular "PO_Number":
    • If the "Status" for All of the records (in the ChildTable) is blank; then the "PO_Status" of the MasterTable should display "Not done".
    • If the "Status" for any of the record (in the ChildTable) has a value "Done"; then the "PO_Status" of the MasterTable should display "Partially done".
    • If the "Status" for All the records (in the ChildTable) has a value "Done"; then the "PO_Status" of the MasterTable should display "Completed".
    Help from the Access programmers will be highly appreciated.
     

Share This Page