In Sharepoint, is there a way to programmatically add a lookup field that refers to a diffent web site?
In the user interface, when we are in a list A, and we are adding a lookup column we can only choose to get the informations from a list B on the same web site of A.
The only way I know is to create a Site column, but in this case the referred list B must be in the root site of the site collection. And this isn't a good thing in most cases.
Is there a programming trick (C#, VB or Powershell) to add a lookup field without that limits?