In the Microsoft SharePoint Foundation, a browse career was a field which is set up to find its worth away from an area in another number.
The manner in which you refer to both listing relies on the point out of examine. Regarding browse field’s perspective, record that provides information is the target checklist plus the industry where in fact the studies arises from is the address community. Regarding address list’s perspective, the list that has the latest lookup career try a related listing. The brand new look field is actually an associated job.
The newest SPList group has actually a good GetRelatedFields approach that you can use to discover browse areas that point to a list.
In the interest of ease, and to prevent misunderstandings, both lists are occasionally considered enjoys a father-guy relationships. The kid list provides the search community. The latest mother checklist provides the data source, which is the career that is the address of your lookup community.
Number Relationship and Study Ethics
In Microsoft SharePoint Foundation 2010, you could configure a search career for the a child checklist thus it metropolitan areas a removal constraint for the belongings in the newest father or mother checklist. When you would or edit a look column from the associate user interface, there is the option to Enforce matchmaking choices. For many who see this, then you can discover possibly Limit delete otherwise Cascade erase. Limitation delete suppresses an item in the parent listing from are deleted in case it is referenced by no less than one related affairs about child list. That have cascade erase, removing a product regarding the parent list causes all related issues to be erased regarding the man number and additionally.
To enable the same conclusion inside the password, lay new RelationshipDeleteBehavior property off an enthusiastic SPFieldLookup target so you’re able to a regard on the SPRelationshipDeleteBehavior enumeration, possibly Restrict or Cascade.
Getting SharePoint Foundation so you’re able to either restriction otherwise cascade deletions, the latest look career need to be listed. Set this new Detailed property of your occupation to help you real.
Hunt and Record Dating
The reason for a deletion constraint should be to impose referential ethics. You apply the constraint should you choose not need a product or service who has a research career is orphaned by the leading in order to a good nonexistent goods on target list.
For example, that is amazing you have a couple of directories, Users and you can Address contact information. You opt to associate both directories with the addition of a lookup field titled Consumer ID on the Address list, while part new look profession toward ID occupation within the the shoppers listing. After you arrange brand new look, you put a restriction to your relationships between them lists because of the indicating that deletions regarding the Users checklist must cascade so you’re able to brand new Contact record. Deciding to cascade deletions enforces referential stability by ensuring that this new Address contact information number will not collect orphaned contact. Of course, if an item are removed out-of Customers, relevant products are instantly removed off Addresses.
That is amazing you additionally have a Pending Requests listing one to, including Details, is related to your People listing by a lookup community you to definitely what to the fresh ID job in the Users. You could select that you don’t need a customers listing to get erased regarding Consumers checklist in case your customer has actually a beneficial pending buy to the Pending Requests record. In this case, you could potentially impose referential ethics of the configuring the fresh search industry with the Pending Purchases in order to limitation deletions on the mother record, People.
An area-aftereffect of opting for often to cascade or even to maximum deletions was your beliefs from look sphere is actually validated when they’re set. An individual brings a different sort of items from screen, brand new look line is actually depicted on mode by a decrease-off listing Arlington escort reviews when your address checklist possess less than 20 situations; in such a case, the user is bound so you’re able to searching for simply valid values. In case the address have over 20 affairs, another type of control is employed additionally the representative need to types of an excellent value; in such a case, typing an incorrect really worth results in red validation text toward form. Comparable validation is done when you use the thing design so you can place the worth of a look job. In cases like this, when your given really worth cannot suggest a preexisting goods to your address listing, SharePoint Foundation places an exception.