When using business rules, you can set Owning Business Unit based on a rule. However, it uses the GUID value, so when promoting to Test Or Production, the GUID is different, meaning the rule wont work. I imagine this is the same with any other lookup. Would it be possible to build in functionality to select name versus the GUID value for the lookup. Alternatively, you could provide the option to lookup an Alternate Key value instead of the built-in functionality. That way, we can make a business rule to set a field based on alternate key instead of primary key field. Advantage here is that alternate key is unique by design, so it should work across environments.

Thanks,

Matthew