SHow Rows with Missing Data in reference table only

[#1]

I am trying to create a bookmark to pull only those records where the data is in one table but no match in the other table.

Example:

Product ID is in Sales table but the Product ID is not yet added to the Product table.

THus the Product Name is Null in the query

I tried the below and no luck

=IsNull([Product Name]) = 1

[deepakk]

hi,

I think it should be

IsNull([Product Name]) = -1 .

If you can attach a sample application then it would be more clear.

Deepak

[#3]

I think I found it

=if(IsNull(ProductField),1,0)

[#4]

I think I found it

=if(IsNull(ProductField),1,0)

[#5]

But it doesn't work with all my validation tables oddly enough.  Works with Product reference table but not with Partner reference table

[#6]

But it doesn't work with all my validation tables oddly enough.  Works with Product reference table but not with Partner reference table