Guys,
I have got one more problem.
My database relation detail
Table.field Link Table.field
Project.JobID ==> Project_cost.JobID
Project.JobID ==> ItempurchasesLines.JobID
Project_cost.AccountNumber ==> Accounts.AccountNumber
Project_cost.AccountID ==> Item.ExpensesAccountID
Item.ItemID ==> ItempurchasesLines.ItemID
What I want now is, I want a full list of accountID in my report from Project_cost table regardless of any record available in ItempurchaseLines. ItempurchaseLines table is linked through itemID field with Item table and Item table is linked with project_cost through field Project_cost.AccountID ==> Item.ExpensesAccountID.
Thanks
mithani