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?