I have created an app for request items for repair spares. I have a Table View for the table named REQUEST. I don’t want to show the request which are “FINISHED”.
The “FINISHED” [STATUS] column is in the next table ITEMS. There is also a ref column in the ITEMS table.
Is it possible that I can show only all the request other than “finished” of the REQUEST table.