hi. i'm very close. i have a cascading drop down on my sharepoint that references to another simple sharepoint list (IGRF_Targets).
the dropdown name for the child is dd_Target but when try using the formula in my UPDATE field, it gives me flags and does not work.
the parent works fine with the same formula in the update field (only difference is exchanging dd_Target with dd_Product).
on sharepoint, these fields were created with "single line of text" if that matters
