Forms master-detail multirecord query

From: McSteve-O <micquest_at_tampabay.rr.com>
Date: Wed, 17 Jan 2001 22:58:18 GMT
Message-ID: <esp96.44543$68.6319719@typhoon.tampabay.rr.com>

Hello all. My eyes are sore from lurking, so I thought I'd post...

In Forms, I have a master-detail record where the detail is queried automatically by the master with the on-populate-details trigger that calls query_master_details (the default forms way to populate the detail record).

My situation is that the detail (persons address) can have more than 1 record match the master (persons name) record; as the case would be if the person moved, I want to keep the history.

The problem is that the query_master_details fetchs the first record (oldest address) instead of the last record (current address).

Is there a setting or quickie fix to change this to select the most recent matching record, or will I need to PL/SQL the information myself, and if so, any suggestions on how to go about it?

TIA, Steve Received on Wed Jan 17 2001 - 16:58:18 CST