Lookup if Code in one Module exists in another Module
I have two staging modules: 1) Account Master, and 2) Account Ledger
What I am looking to do is populate accounts from the the account master where the accounts exist in the ledger. I don't want to populate ALL the item in the account ledger since there are items which are no longer used, or that are "helper" items for JD Edwards, and not live account strings.
The formula I am looking to write should check to see if the [Account Master] ID exists in the [Account Ledger], and if it does, then I want these items to populate the list hierarchies related to the account string.
2) Account Ledger
Line Items mapped to the same list as the Account Master shown below
1) Account Master - The Account Master is dimensionalized by the red outlined code (which is the same code shown in the above module: "GLAID". I can successfully map to the Account Ledger here, but I want to to lookup the modules the other way around (For example: does code "00004571" exist in the Account Ledger module shown above? account master ID's can be found in the Account Ledger line item: GLAID)
"Exists in F0911" should check to see if the Account Master CODE exists in the Account Ledger
I would really appreciate help on this, I cannot seem to figure it out...