Newbies Anax Posted February 1, 2012 Newbies Posted February 1, 2012 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.
Fitch Posted February 2, 2012 Posted February 2, 2012 It sounds like maybe you're wanting a conditional value list: http://help.filemaker.com/app/answers/detail/a_id/5833
Newbies Anax Posted February 2, 2012 Author Newbies Posted February 2, 2012 Fitch , i really really really really thank you for your quick and very big help.
Recommended Posts
This topic is 4934 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now