2 Replies Latest reply on Dec 26, 2010 10:45 PM by a_sun

    filter drop-down list value?

    a_sun

      Title

      filter drop-down list value?

      Post

      Hi:

      I have search over the answer from the forum, but I cant figure it out.I have a table -JOB ticket and Inventory.

      In inventory layout, I want to create a drop-down list that display the job number that Status job ticket is "New"How would I do that? 

      I been tried this method:
      I created a text field in inventory table => xconst_job

      *If (JOB ticket::status="New";JOB ticket::_kp_jobticket_id ; "xconst_job" ) 

      *relationship xconst_job <-> status


      But the result came out all value list, it doesn't filter out.

      Any step i missing out?

      Possible to give me sample file?