Query Challenge!

Can some one help with this query?

Here's the scenario;

There are 2 UDF's that need the same data...

The first UDF (BinID_ItemMaster) is in the Item Master Data Table.

The second UDF (BinID_BOM) is in the BOM at the line item .

When a new Item is created, a bin location is assigned. (BinID_ItemMaster)

I need the (BinID_ItemMaster) to populate the (BinID_BOM) using (I guess) a formatted search.

Thanks in advance for any help,