AnsweredAssumed Answered

Solution required for make a script

Question asked by Suresh on Jul 28, 2016
Latest reply on Aug 2, 2016 by Storganise

Dear All,

 

I have 4 tables,

 

Table1

Table2

Table3

Table4

 

Table1

  PK_ProdCat

  Cust. Name

 

Table2

  FK_ProdCat

  PK_Failures

  Tab2Score

 

Table3

  FK_Failures

  PK_Functions

  Tab3Score

 

Table4

  FK_Functions

  PK_Cause

  FK_ProdCat

  FinalScore

  Find

 

 

So In table4 i need find the match ProdCat in "Find" field, this could be Drop-Down & ValueList fetch from Table1's ProdCat field.

 

Here i need to prepare a script that What I have selected from "Find" field's ProdCat Value only, need to be disply(TableView), rest of them could be Omit.

 

I dont have any idea how to make, Please suggest me for best.

 

Solutions much appreciated!

 

Thanks in advance,

Suresh

Outcomes