Skip to Content
0
Former Member
Dec 26, 2009 at 05:25 PM

Record Selection

10 Views

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