I assume this is simple enough, when you know how :)
I retrieve 2 files, pricelist with multiple information such as number, price, desciption and so on,
the 2. file is discount file, with 2 fields : discountcode;discount like G30;48
which means discountcode = G30 which equals 48%
I have a program to read the pricefile, but in order to get the right discount without having to build the exact codes into the program, I would like to read the discount from file perhaps into table/records and then determine for each number what the discount should be, also I would like to exit the discount reading when the right code i hit, since the priceprogram have to read around 120.000 numbers.
So I seek a solution and maybe a simple "How to"
John