AnkurSanghi
Member
The scenario is:
Left outer join business view joins table F4311 and table F4311T (custom tag table with same key as F4311). Objective is that the F4311 data shows even if there is no corresponding records in the tag table F4311T.
I use this on a Form grid and the data shows correctly except when I do a QBE on a fields that belongs to the F4311T. When doing so the desired data set is records that match the QBE value but instead I get all the data that matches the QBE value along with all the records that do not exist in the F4311T.
Any thoughts on how to work around this?
Thanks
Left outer join business view joins table F4311 and table F4311T (custom tag table with same key as F4311). Objective is that the F4311 data shows even if there is no corresponding records in the tag table F4311T.
I use this on a Form grid and the data shows correctly except when I do a QBE on a fields that belongs to the F4311T. When doing so the desired data set is records that match the QBE value but instead I get all the data that matches the QBE value along with all the records that do not exist in the F4311T.
Any thoughts on how to work around this?
Thanks