"3rd" generation relationship
Posted: Fri Oct 07, 2016 11:41 am
This is a bit perplexing for me so hopefully I am just being short sighted here but I have 3 tables.
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:
It never returns any data for the products so my column for product name will be blank. I would appreciate a hint at where I am going wrong.
Thanks
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", theConditionsThanks