Hey DBlank
The mullev part is correct, but beside the suppycode and supplyname it also has current stock value's, price , tax info , ....
the 4 other's are the files we get from the supplier himself
that one has
product number / suppliercode / price / stock / taxinfo / ....
becouse i only need the code andthe name i use a union all to get 1 BIG list of all the supplycodes and the cupply name
this i make on the SQL server in a view
then in CR i load my mullev DB and the view
This in the hope to make a list of all the supply codes availeble in the mullev but not in the view (aka EOL products)
Adam
IP Logged
