products (products)
poheader (purchase order header)
podetail (purchase order detail)
I have defined relationships between the poheader and podetail tables as well as a relationship between the products and the podetail table but there is no direct link between products and poheader table. When I populate data for the grid:
Code: Select all
put sqlquery_createObject("poheader") into theQueryA
sqlquery_set theQueryA, "related table joins", "LEFT OUTER JOIN suppliers, LEFT OUTER JOIN podetail, LEFT OUTER JOIN products"
## Specify how results should be sorted
sqlquery_set theQueryA, "order by", "poheader.poh_ID"
sqlquery_set theQueryA, "conditions", theConditions
Thanks