Hi Jason,
That's the problem...I did have it working but when I upgraded I inadvertently deleted the recordset because I thought I could be smart and recreate without any problems.
I'm nearly there I just forgot the steps.
As the image attached shows, the last three columns are from the allocated table, with the others on the left coming from the other two tables and space where they have not been allocated yet.
Sorry to be a pain..
Andy