Hi all,

I am trying to work with Invoices and the programs looks fine the only thing i want to change is that in the Menu -> Invoices -> Product Id. I want to add a button in the left of Products Id called "Find" and when i will insert an Id for example 3 and press the botton, i want to appear a drop-down menu to the current Line Item and show me a list of Id, Name of producst that have similar name as the name of the product that i entered. I came with an algorithm in my mind but i have never worked with FileMaker scripting and i dont know how to implement this

 onButtonClick {

		  myId = take from the current selected line item the Product ID;

		  myName = find the Product Name that corresponds in this ID;

		  execute the query (SELECT Id, Name FROM Products WHERE Name LIKE '%myName%' AND Id!=myId;)

		  create a drop-down list in the current line item;

		  put the result of the query.

}

Ι would really appreciate it if someone could and would like to help me, Thanks in advance.

It sounds like maybe you're wanting a conditional value list:

http://help.filemaker.com/app/answers/detail/a_id/5833

Fitch , i really really really really thank you for your quick and very big help.