how filter single table solution

[saghira]

I have one table name "payment" ' , any have two layouts , "PAY" and "Wait" 

on table there is drop down field named  "Status" , which have two values "Pay" and "wait" .

I want when I change status "Wait" to Pay  it shows on "pay layout " and in "wait layout " shows only record with  status "wait".

 

[comment]

I don't see how this is different from your previous question:
https://fmforums.com/topic/109822-help-ommitt-record-in-layouts

 

To  recap: layouts do not filter records. A layout will always show the current found set. If you want to remove a record from the current found set you must either omit it or perform a new find.