Cascade Deleting Element from Secound List after chosse the elements from first list

Question

I must do Cascade Deleting when I delete one Element in First lists, it's deletes me all bounded elements from another list's. I only must set a lookup fields at Adding Items. When I chose by editing its delete me all elements, but I don't know how to set lookap field and choose element. I find this article, but it isn't work: http://sarangasl.blogspot.com/2009/12/add-item-to-list-with-lookup-column.html, or I cant understand. Please help.

Edited:

Here of my shotes Code of items add:

 SPListItem item = lstOtherList.Items.Add();
                           item["Kontrakt"] = properties.AfterProperties["Kontrakt1"];
                           item["Pracownik"] = properties.UserDisplayName;
                           item["Dzien"] = dzienStart;
                           item["Procenty"] = properties.AfterProperties["Procenty"];

I made too Look Up Column caled "ID Czas Pracy Wpisy".

Edited 13:36

I have got two List's: First list has got elements:

                Contract | Worker | Day Start   | Day Stop   | Percent
                --------------------------------------------------------
 Example        Con1     | Paul   | 2012-10-12  | 2012-10-15 | 1/8

Secound List should have

                Contract   |   Worker   |   Day      |   Percent
                ------------------------------------------------
Should Have     Con 1      |    Paul    | 2012-10-12 |    1/8
                Con 1      |    Paul    | 2012-10-13 |    1/8
                Con 1      |    Paul    | 2012-10-14 |    1/8
                Con 1      |    Paul    | 2012-10-15 |    1/8

So In Secound lists I want to have a for examle name of contract which can't repeat as lookap fild, but i must set ap this value when I make a Secound List.

Answer 1

Hi please go through this documentation you will find everything you need to know here, go to the last of the page directly to know how to create the lookup column and if you want you can read the rest for detail information

---

If you have to accomplish the task with code

SPList firstList = site.Lists["FirstListName"];
SPList secondList = site.Lists["SecondListName"];
string strPrimaryCol = secondList.Fields.AddLookup("Lookupfieldname", firstList.ID, true);
SPFieldLookup primaryCol = (SPFieldLookup)secondList.Fields.GetFieldByInternalName(strPrimaryCol);
primaryCol.LookupField = firstList.Fields["ID"].InternalName;
primaryCol.Indexed = true;
primaryCol.RelationshipDeleteBehavior = SPRelationshipDeleteBehavior.Cascade;
primaryCol.Update();

but what i dont get is how do you plan to use this code in itemadding event, what are you trying to achieve?

---

I think I got your initial question wrong you wanted to add value to lookup field in itemadding, not creating the lookup field, for that purpose you need to use SPFieldLookupValue, just use item["Look Up Field Name"]=new SPFieldLookupValue(lookupid, lookupvalue);

that's it, read the msdn documentation if you want