in OUVRE action you can "open" more tables or views:
for example: If clalev([F:SDH])=0 Local File SDELIVERY [SDH] Endif

thanks Barak - I already tried putting the clalev statement in my code (see below)
Can you help me with this problem?
I'm trying to add to the filter that is used to displays the components of a Work Order in the Production Tracking (Material) transaction. Basically when stock is received we enter a Pallet Id (PALNUM) and I want to incorporate this to filter the components displayed in production tracking so that only the components included on a given Pallet are available to be tracked. On the STOCK file, the STO1 index comprises FCY, PALNUM and ITMREF so I'm trying to use this at the entry point MFMFLT but it's not working. i don't know where to tell it to link the MFM table to STO table

$ACTION
Case ACTION
When "MFMFLT" : Gosub SPE_MFMFLT
Endcase
Return


$SPE_MFMFLT
if [M:MTK0]YPALNUM <> "" #screen field used to enter req'd Pallet ID

If clalev ([F:STO]) <= 0 : Local File STOCK [STO] : Endif
CRITERE -= "& [F:STO]STO1 = [F:MFM]MFGFCY;[M:MTK0]YPALNUM;[F:MFM]ITMREF"

endif

Return


thanks

thanks Barak - I already tried putting the clalev statement in my code (see below)
Can you help me with this problem?
I'm trying to add to the filter that is used to displays the components of a Work Order in the Production Tracking (Material) transaction. Basically when stock is received we enter a Pallet Id (PALNUM) and I want to incorporate this to filter the components displayed in production tracking so that only the components included on a given Pallet are available to be tracked. On the STOCK file, the STO1 index comprises FCY, PALNUM and ITMREF so I'm trying to use this at the entry point MFMFLT but it's not working. i don't know where to tell it to link the MFM table to STO table

$ACTION
Case ACTION
When "MFMFLT" : Gosub SPE_MFMFLT
Endcase
Return


$SPE_MFMFLT
if [M:MTK0]YPALNUM <> "" #screen field used to enter req'd Pallet ID

If clalev ([F:STO]) <= 0 : Local File STOCK [STO] : Endif
CRITERE -= "& [F:STO]STO1 = [F:MFM]MFGFCY;[M:MTK0]YPALNUM;[F:MFM]ITMREF"

endif

Return


thanks

sorry , I'm no femilier with the Production Tracking but according to help about it you can filter only MFM table and I don't think you can link to other table at that point...

I also think there is no way to filter on more then 1 value...

OK THanks Barak. I'll have to try just using code to filter the list instead of the entry point filter