Skip to Content
0
Former Member
Sep 03, 2009 at 02:14 AM

Database Relation issue

13 Views

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