>Hi,
>
>I have the following table Descriptions:-
>
>Item No. -- Supp1-- Supp2-- Supp3 .... Supp10
>
>
>I want to have a list of items for each supplier on the tables showing the following:-
>
>Header is the Supplier No.
>Details of each item Item No
>
>
>Thanks for your help
Could you post some simple data and what you want from it?
IMO if you keep data like this this is BAD design. What would happen if you have Supp11 or 12 or 3723?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.