Join Datasource in Form which has no relation in table Level

Hi all,

I’m new to to this community… I need one help

How to join datasources in a form , which has no relation in table level.? I have to create a relation between purchtable and purchreqbusjustification table in form level to get value from purchreqbusjustification table…

Thanks in advance…[:)]

You can change form’s query at runtime, by adding links between the two datasources. You can use QueryBuildDataSource.addLine() method to do that, which is typically invoked from init() method of a form datasource. Search AOT form for “addLink” to get some concrete examples.

HI Martin,

Thanks a lot for ur reply…I’ll try and post the output…