I have two lists which are linked. When I want to add a record to the second (child) list I need to get data from the first list (parent). My parent list "PIR" has the fields PIR, number and source. The child list "SIR" has the fields SIR, PIR2SIR, number. The field lookup field PIR2SIR is linked to PIR in the parent list.
example: PIR: this is my question. number: 1 source: CNN
SIR: this is my sub question. PIR2SIR: this is my question. number: 1.1 source: CNN
Now I want to add a new SIR record. When I load the Newform I need to have the number of the last SIR record, being 1.1. because I want to autofill the number of the new record like 1.2. I am using jquery to do this.
The problem is that more PIR questions can be number 1, depending on the source. I am breaking my head to get this done.
Marco