Filter rows

How do I filter rows in a table? On a form I want to only show that rows from the Sales Invoice table, where the Post Desciption are bills. How can I do that? I hope you will understand me!

where are you tring to do?

manually in forms/tables or at run time through coding?

If manually, select the field in table/form, press F7 and your value

If in coding,


Check this out

Check this out

Lookup the SETRANGE and SETFILTER commands.