This (create a trigger in the header file that updates and re-files the detail item(s)) is what I have done on D3 systems. The only thing I might add is that I phantom off the update and include a 'sleep 5' (typically create a run-once proc and phantom that off) so that when the detail update happens the header has already been filed. It's not elegant, but it does work.
Scott Ballinger Pareto Corporation Edmonds WA USA 725 670 0831 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: Wednesday, November 03, 2004 12:06 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Index problem [snip] Another work around is to have a trigger on the header file re-file the detail items that reference it so that the index is properly updated. I'm not sure if you'll have to "change" the detail item or not for it to cause the index to be updated. [snip] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/