AnsweredAssumed Answered

filter drop-down list value?

Question asked by a_sun on Dec 23, 2010
Latest reply on Dec 26, 2010 by a_sun


filter drop-down list value?



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?