I have a “MAINTENANCE” table with a column named “N.S” that refers to a “GSE” table.
In the table “GSE” .- (column “N.S” numbers), (column “STATE” inoperative).
In the “MAINTENANCE” table, how can I display only the numbers in the “N.S” column that are inoperative
In the “GSE” table?
It might be helpful to create a slice of “Inoperative” records from the GSE table.
I would make a slice to hold the Inoperative records, then use the slice to restrict the options for your reference by using a Valid If formula like this:
You can read more about slices here:
thanks but I have already created an inoperative slice.
in the maintenace form screen when I have to assign in the N.S column all the operative ones also appear
For the Valid If expression for the N.S column of the MAINTENANCE table, try:
SORT( SELECT( GSE[N.S], AND( ISNOTBLANK([STATE]), ([STATE] = "inoperative") ), TRUE ) )
thanks a lot!!!