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!!!