As well as refining the standard SharePoint lookup column, skybow offers the Data Lookup control that can lookup data from lists across sites. This is useful if you already have a list in another site to lookup from, and you don’t want to duplicate that list for the purpose of a lookup column on your form. The user completing the form will need to have at least "Read" access to the list that you are looking up from.
To add a Cross-Site Data Lookup Column on you SharePoint Form you need to complete the following steps:
- Add a control to your form with the "+" button.
- From the "Add" dialog, click ‘Data Lookup’
- Provide a display name for your column and an internal name.
- Provide the Site URL for the site containing the list
- Select the list from the site that you wish to lookup from.
- Select the column that you would like to use in your Data Lookup column.
- Refine the other properties such as "Allow Multiple Values", "Require that this column contains information" and "Display as text only"