Storing a ProdID's BOM Value into that ProdID's InventBach Form's Record....?

Hi All, My Requirement goes Like this… In ProdTable Form we have a Field Called “ProdStatus / Status” (this is a Enum Field have Values Like 1)Statred , 2) Released , 3) Report as Finished) So, Now When ever this ProdStatus Field Changed as “Report as Finished” I want to get that Selected ProdId’s BOM (Every Production Order has BOM Record) record and store that BOM.ItemID in Some other Form Called InventBatch Form. Please Share your suggestions… Thanks in advance…