Clicking on a column assigned to another column

[#1]

I have a table as below

Supplier ID Status
--------+----+---------+
ABC 100 Complete
ABC 200 Complete
ABC 300 Pending
DEF 400 Complete
DEF 500 Pending
DEF 600 Pending

By default, when I click on Complete on the first row, the result set will be

Supplier ID Status
--------+----+---------+
ABC 100 Complete
ABC 200 Complete
DEF 400 Complete

I would like to have the option to drill only on a specific row. For instance, when clicking on Complete on the first row, I would like to only see the record where ID = 100 and not all the records where Status=Complete.

Is there a way of accomplishing this without clicking on the ID itself ?

Thanks.

[#2 · Accepted solution]

For this behavior I would suggest a unique status field per ID, it is easily created with a dual. See attached app.

Tom

[#3]

Thanks Tom ! This is exactly what I'm looking for.