I have an inner join query using Access as a back end I have put the query directly into the DB and it runs fine, but in the code it keeps coming up with the msg -

Cannot create a child list for field Items.

This is the query

SELECT Items.ItemID, Items.ItemNo, Items.Type, Items.Colour, Items.LabourCost, Items.ParSurCost, Items.FullSurCost, Items.PaintCost, Items.ItemCost, Items.Percentage, Items.BillingPrice, Items.Priority, Items.PrepEUs, Items.WinFabEUs, Items.DoorFabEUs, Items.CrimpEUs, Items.FinalCheckEUs, Items.JobRef, Items.Location FROM Job INNER JOIN Items ON Job.JobId = Items.JobID WHERE (((Job.JobNo)= 'O1642'))

Not sure why this is happening if the query runs? What am I doing wrong?

Thanks

Louisa

hi there..

maybe you have a problem with your code?? can you paste some of it??? specially the part that throw the error

HTH

Gonzalo

It falls over when I call the class code below

Dim Itemsdata as new DataSet

Itemsdata = CItems.ItemsReport

Thanks
Louisa

ok... so far so good.. but what happends inside CItems.ItemsReport ??? maybe the error is inside there....

HTH

Gonzalo

Perhaps the problem is that you misspelled “color” and “labor”? :)

Having only a limited view into what you are doing, my first guess would be that there is a section in your report that displays a group of records subordinate to each record in the SQL you provided, and that the SQL you provided lacks an output field that is to be used to link the child records to each record in the SQL you provided.

If you try just opening this SQL as a recordset, standing on its own, does it fall over?

I have altered my mapping of the table and it now works, what I still don't understand is why it falls over at the query when the mapping comes later?

Thanks for your help

Louisa