At 10:08 PM 5/06/2006, you wrote:

> >
> > Try improving the syntax for the main query:
> >
> > select s.rec,s.shipment,s.whs,s.pid,s.qty,s.alloc,w.description
> > from warehouses w
> > left outer join shipment_allocations s
> > on s.whs=w.ref
> > WHERE s.shipment=:shipment and s.pid=:pid
> >
> > Helen
> >
>That breaks it, I always want the grid populated with fields from warehouses
>even when there is no data in shipment_allocations. Changing it as you
>suggest returns no rows ;-(

That sounds suspect. Where did you test it?

What's the PK of warehouses?

Helen