OPO List Objects in Repeaters

Here I go again, thanks for patience beforehand.

I started out wanting to have a parent form with 2 repeaters on it, each a child of the parent for recid. I wanted to be able to coordinate info in the second repeater with both the recid of the parent form and the recid of the first child repeater.

I simplified things and used 2 child embedded forms on the parent form and used Michael Kranzdorf's post change() method on the foreign key field of the first embedded child form:

inherited.postchange()
child2.pop_name.translation = "=select ....." '" self.value & "' "

But it did not show new additions to child1 in the child2 pop-up until I added a child2.popup.updatelist() after the re-definition of the translation.

So, I started to add things back into the bare form to get what I wanted - I turned the child1 embedded form back into a repeater and discovered that I had to reference the recid of the repeater by creating a recordset object and doing getcolval(colname) for each of the child2 translation list on the recordset object.

Still well & good as long as the 2nd child was an embedded form.

When I turned the 2nd child into a repeater, I had to make a global object of the popup recordset that referenced the child1 repeater recordset, and insert a record into the child2 popup recordstd in the child1 repeater postchange() method.

It worked up until I tried child2.repeater.popup.updatelist() and got told that only aggregate functions worked in repeater fields [not the 1st time I've seen it].

The new child1 recordset info does get inserted into the child2.repeater. popup, but the change is invisible. You see the same popup choices in the 2nd repeater popup, but if you pick the 1st, you get the newly inserted info, if you pick the 2nd, you get the old 1st choice, and if you pick the "blank space" at the end of the popup, you get the old last choice.

After all this, I won't go into my attempts to move the insert into the 2nd child popup and all my stack overflows, etc.

Maybe my brain is just burnt from having gotten this far. What have I missed to redraw the rptChild2.popup recordset after having successfully (finally!!!!!!) stuffed another row into it? [next try is to set child2 popup to last recordset row + 1 then assign col vals, but I'm pooped out]

All suggestions gratefully appreciated,

Barbara Worthing-Jones

ps - I do remember seeing something about out of stack space in OPO, but haven't been able to find the thread again. If anyone has a copy please forward it - thanks again, bwj Received on Wed Aug 30 1995 - 00:00:00 CEST