Hi

I have 2 tables with a 1 to many relationship a Pipeline table which
can have several impacts (impacts table).

What i want to achieve is a form in datasheet view where the impact
columns are are simply stuck on the end of Pipeline table. Ideally, i
would limit this to 3 sets of extra columns on the end based on the
top 3 impacts but would also be happy with showing as many extra
columns as there are impacts.

Should i be dioing this in a form/subform setup or is there a way to
produce this in a query?

Hopefully this makes sense. Thanks for any suggestions.
Paul