2

I want in view display records only from 1 form, it's possible to block all other records from other forms and display for example only from "Products" form records ?

Second question is how to hide empty recprds ? I want if all view fields is empty I don't want show this record in view.

Wizard
  • 10,985
  • 38
  • 91
  • 165

1 Answers1

6

Add a select formula to view

SELECT Form="Products" & !(Field1 = "" & Field2 = "" & Field3 = "")

enter image description here

Look here for more information about Selecting which documents display in a view

Knut Herrmann
  • 30,880
  • 4
  • 31
  • 67