Thanks. Parent 3 only has 1 name (Andy) but 3 destinations (Albany, Malaga and Texas) in the child table.
The examples I have given is rather simplistic as each route (the child record) will have at least 30 different fields, not just the ones shown (ID (autonumber - not required for output)...