Good day.

I have another problem. =( .

I have a mater detail setup in my application. I want to perform a check
first before saving the records to prevent duplicate entry of invoices.
So in the master dataset before post i have something like this

if masterdataset.state = dssinsert and not masterdataset.ispostretaining
then
// search for possible duplicate records code is here

I use the invoice no as search criteria in searcing for the duplicate
records ... what happen is since ther is a postretain that happen when a
detail dataset record was post. the search for duplicate records result
to finding the current invoice since it was postretain ... how could I
able to do such things that my search wont see the post that was retain?

As of now the solution that I have is to use a different transaction for
searching the duplicate since it is not yet committed but I feel it is a
long solution ... There might be a short solution I guess from you
experts =)

James