Array problem

[JRBeltman]

Hi,
I am trying to read and compare a field in my database.
The information in the database looks a bit like this:

-----------------------------------------
- Customer no -- Invoice no -- Matchref -
------------------------------------------
- 001 -- 001 -- 123 -
- 001 -- 003 -- 321 -
- 001 -- 004 -- 123 -
- 002 -- 005 -- 234 -

I want to detect when the same Matchref for a customer has already been read and take action depending on that.
Ie. if for customer 001 matchref 123 is read a second time I want it to display a message telling me this.

I thought of using an array, but have some issues.

Any ideas?

JR
IT = Logic (except for a well known OS where it equals luck) -> Back to the Basics!

 

[lupins46]

Can you just group on customerno and matchref and count the entries?

 

[JRBeltman]

Hi,
unfortunatelly this database is constructed in such a way that this is impossible.

However I did find a way of getting the array to work. But how can I resize the array on the fly?

Thanks


JR
IT = Logic (except for a well known OS where it equals luck) -> Back to the Basics!

 

[lupins46]

Redim
or Redim Preserve

 

[JRBeltman]

Well,
I discovered that the database structure needs a completely reversed approach. Thanks for your help.



JR
IT = Logic (except for a well known OS where it equals luck) -> Back to the Basics!