I have two content types - Company and Employee.

Company is the parent. For production purposes we need to keep track of which companies do not yet have employees associated with them. I tried to do this with Views but the only type of relationship I was able to establish was on the parent. If I don't establish a relationship then I have to filter with both content types and in the query it shows both Company and Employee records as I have to call the Node Title.

So how can I generate a query (preferably Views) that would list all Company nodes- with or without children - OR a query that shows JUST the nodes (companies) that do not have children?

Comments

cspbm’s picture

cspbm commented

Any ideas on this? I had tried Views, but that doesn't work as I need to list all parents showing which have children and which don't. Views only lets you create a relationship using the Parent ID not ChildID.

Any help would be appreciated.

oda’s picture

oda commented
Status: Active » Closed (duplicate)

Check it out: http://drupal.org/node/844002