I am selecting records based on head of household/spouse, but I want to still include records that have no spouse at all.

The following record selection formula returns all head of household records:
(relationship-headofhousehold)=FALSE

However, it eliminates anyone without a spouse.  I have tried something like this to make it work:

(relationship-headofhousehold)=FALSE OR (spouse link) = ' ' (or 0)

Nothing ever works when I try this.  I either end up with no records, or I end up only with records that actually have a spouse.

In general, the question is: How do I specify records I want to see within a table, but also show records that are not even in the table I am selecting on?

Any help is greatly appreciated, again.


Edited by JFinzel - 21 Jul 2011 at 7:10am

Let me see if I understand you correctly.

Suppose my main constituent table goes up to number 483.
I also have a table that has spouses.  This table goes to 456.

I want to find people who are in table 1, but have no spouse in table 2.

I also need to find who is head of household from table 1, but I already know how to do this with another condition and table that I have.

Are you saying that I can't get the information by doing a formula like so:
(Const. is in table 1) and (Const.Spouse is not in table 2) [i.e. Const. has no record in table 2 for spouse]

?

I have already run into many cases where this would be helpful.  Is it not possible to do a formula like this?

Thank you!


Edited by JFinzel - 21 Jul 2011 at 8:51am