Hi all,

I'm nearly pulling out what's left of my hair at this!

I have two tables in MS Query, one which I need to display all data from,
and the other from which I only need to display data if it relates to the
first table... basically an outer join? Trouble is, the link between the two
tables is a set of three fields; Requisition Number, Line Number, Release
Number. I can't set more than one outer join. What I'm trying to get is a
list of requisitions from first table, with order info (if available) from
second.

I've tried a whole outer join, but the fact that the query takes a parameter
completely throws this out.

Does anyone have any advice on what to try next?

Cheers,
Marc