Skipping duplicate records on form.

Roelof

Hi,

I am trying to skip duplicate records on a (matrix) form. How can I do that? (using a temp filed and triggers like: FindRecord and NextRecord?)

Second question: if I use a matrix form and I would use a temp. file, do I mess up with matrix table connections, so that the cross-ref link is gone?

Thanks.
Roelof.

MChilari

You can use Temporary Table to Fill the Matrix form. While Creating Temporary table you can skip the Duplicate Records, have a look at "Purch. Analysis by Dimensions" or "Sales Analysis by Dimensions".

By using Temporary tables you not going to messup the Matrix Form relations.