Unfortunately, FileMaker does not have the ability to do left outter joins. However in your case you probably could get around it somewhat.
Base your report layout off of the Query table. YOu can use a portal to show the history. Make the portal as large as you think a possible history can get. You can turn on sliding of the portal, fields, with the option to reduce enclosing part to make sure that the empty rows slide up.
Thanks a lot for replty I was not suer if Filemaker pro does left outer join.
I have the protal one but my boss says if I can do it like a List layout.
Thanks a lot