Show If function

Timbo
New Member

Hi All

I am building up an application and am having trouble with the โ€œshow ifโ€ function
I have connected multiple tables and included them in the master form with the โ€œpart ofโ€ function, issue is that I want the table to display as a result of multiple selections from the list.
eg if list one was โ€œtyre inspectionโ€ I want it to appear when the user selcts vehicle type from a drop down of either โ€œCar or Truckโ€?
Would have thought it would be as simple as show "[Type]=Car or Truck. is there a seperator i need to use in the formula to make this work?

0 3 336
3 REPLIES 3

Use IN([Type],LIST(Car,Truck))

Thanks Aleksi!

Youโ€™re welcome

Top Labels in this Space