Hi guys
I have got two tables
One has got details about all the costs by cost lines (each record) and the other table has got certain breakdown for that line (which is not always the case so you will have records in main table which has got not record in second table. Now I want to saw them in dashboard, when I load them, records in main tables gets duplicated for the records appearing in second table.
I just want to saw the data in second table along with main record from first table, albeit in diff objects for dashboards.
Any ideas.... Can we do a left outer join in table viewer ????
Thank you very much