Hi,
I have a Master - Detail relationship with the DetailDelay property of the Detail recordset set to 200.
In my code, I create a Master record and POST it to the database.
I then create a Detail record with an incremental ID based on the number of records in the Detail recordset + 1.
eg. ItemNo := Detail.RecordCount + 1
However, it seems that because the DetailDelay is set to 200, on creation of a new Master plus Detail, the Detail ItemNo is set to the previous Master's Details record count.
Is there any way round this problem without setting the DetailDelay to 0?
Many thanks,
Michael