Array or Parameter or another solution?

[purvy]

I have a list of 2800 records of people with (various) postcodes in a corporate database.
I have a separate list of postcodes relating to our borough (7099) records in an access database.
I want to be able, in Crystal, to produce a list of people who are not in our borough (ie their postcodes are not on the Access list).
I've thought about using an array but there are too many records to put into one.
I've tried importing the list as a picklist into a parameter and doing {corresp_address.postcode} in {?postcode} but that doesn't appear to be working properly.
Any help or suggestions would be greatly appreciated!
I'm using Crystal 8.5.
Thanks

 

[MisterMo]

what type is the corporate database ?

SQL or Oracle could easily be linked onto access and then used in crystal

Mo