Refreshing a Column Value in the Master Table

[Raabi]

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.

 

[MStef]

Hello Rabbi!

Look at "DemoRefreshingA200.mdb"
Open main form and try.

 

[Raabi]

Thanks MStef. I will try your solution and may get back, if needed.

 

[Raabi]

Very special thanks to MStef, for providing just custom tailored solution to my problem.

Have a great day MStef.