CRXI, link table fields to exclude data 1

[mgason]

Hi,
I have 3 tables. Each has a field batch_id.
In my record selection statement I select batch_id's from tableA whose timestamps fall between a start and end parameter.
tableB is linked and I get data for those same batch_id's.
tableC is my problem. I want to exclude any batch_id that appears in TableC.

How do I set that up?

thanks
mark

 

[hilfy]

Join from TableA to TableC (direction is important here...) Right-click on the link and select Link Options. Select "Left Outer Join". This will cause all of the records in TableA to be included, whether or not they have a corresponding record in TableC.

In the Select Expert, edit the selection criteria and add something like the following:

and IsNull({tableC.batch_id})

This will filter out any records that have a corresponding record in TableC.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[mgason]

thanks
I think it is working just as desired
mark