Setting SourceTableTemporary to Yes on a subform does not seem to work. Probably i am doing something wrong…
I have a (card) form where can browse through table A. On the subform i want to show the records from table B that correspond to the record from table A. Table B has a lot of records, but for every record in A only a few records in B match. I need the records from B that satiesfiy filter1 OR filter2 OR filter3.
In the OnAfterGetRecord on the cardform i call a function on the subform to populate the sourcetable of the subform. I can trace the code to the point where it inserts the records in the temporary table. But no matter what i try, the records are not shown
I am using Nav2009 on Sql Server