hi, i cant figure out the code to display only one of each record.
Each record has many colours and sizes so the database has the same item_code.
For a query to add new colours, im after the small command to only display each record once, and not all instances of it.
Hope this makes sense...