Record Selection

[Former Member]

Tool.Name___Op.Desc___Op.Std

Binder______Setup______0

Binder______Run_______200

Binder______Maint______0

Binder______Repair_____0

Folder______Setup______0

Folder______Run________300

Folder______Maint_______0

Assembly___Setup______0

Assembly___Run________0

Assembly___Maint_______0

Two tables: Tool and Op

Join: One to Many linked by Tool.Name and Op.Name (not shown)

I want to select all records in the Tool table except those records where Op.Std = 0 for Op.Desc = Run.

Here is the intended result. Note that ALL joined Assembly records are now excluded and that ALL Binder and Folder records remain because their Run code is greater than zero.

Tool.Name___Op.Desc___Op.Std

Binder______Setup______0

Binder______Run_______200

Binder______Maint______0

Binder______Repair_____0

Folder______Setup______0

Folder______Run________300

Folder______Maint_______0

I know there are ways to accomplish this with conditional suppression, but in this case will give me other headaches. Can it be done within Record Selection?

Thanks,

Art

[Former Member · Accepted solution]

i would suggest to join the tables on a distinct foreign key, names are not good if they are entered incorrectly. is there a guid or id field associated.

use left outter joins.

will you always eliminate the Op.Std = 0 for Op.Desc = Run?

if so in the record selection type

if Op.Desc <> Run and Op.Std <> 0 then true

if it needs to meet those conditions.

if it changes each time an end user runs the report than create parameter.