Problem in Datasource join based on field value not on table relation in form

Hello frnds,

I am facing problem to join two datasource on the basis of field value of tables, not on relation based.

actually i am using a common form for three place entry,confirmation and posting

in entry there is direct relation with header and line table on the transporter field value

where as in confirmation and posting form i have relation based on transporterid and auto number (which is inserted in line table on entry form)

Simply i want to join datasource based on field value not on given table relations in form

pls help me!!!



One way is to have enum field which differentiates them and use conditional relations or you can build the relations dynamically in the form

Thanks Kranthi,

Your Idea works for me!!

I have used DynaLinks in form DataSource