Hi there,
I have three tables i.e branch master , Disbursement and outstanding. Branch code is common among all three tables hence i have created a relation with both tables using branch code from branch master to branch code of respective tables.
I need to report a data in format which will populate branch code wise disbursement and outstanding in single report. When i run the query taking two tables either i.e branch master and disbursement or branch master and outstanding output comes correct but the moment i take all the three tables , output comes out weird. Not able to figure out what would be the issue.
Any suggestion or help will be appreciated.
regards
Vinod Krishna
I have three tables i.e branch master , Disbursement and outstanding. Branch code is common among all three tables hence i have created a relation with both tables using branch code from branch master to branch code of respective tables.
I need to report a data in format which will populate branch code wise disbursement and outstanding in single report. When i run the query taking two tables either i.e branch master and disbursement or branch master and outstanding output comes correct but the moment i take all the three tables , output comes out weird. Not able to figure out what would be the issue.
Any suggestion or help will be appreciated.
regards
Vinod Krishna