I generally like to use joins and avoid repeated data as much as possible, but it can take a SQL expert to write the necessary queryies to succeed at that task.
thanks ray, so far i have used joins so probably best to stick with that method at moment.
thanks for your help,
one thing you cannot create a chart from a recordset in the wizard can you? only via the xml file?