Link to home
Start Free TrialLog in
Avatar of perbackman
perbackman

asked on

Question on example plug-in.

I have a table with companies.
I have a field in each post called "Fld_compname". (Unik data)
I need to make a pull down menu that on change, finds one companie. Data in the menu should be the companynames to choose from.

I have a global field "FindCompanie" that apears as a pull down field. Current data is last search.

I installed the examplePlugIn that can run a script dependiing on a formel value.
So far so good.
I compare the Fld_compname and FindCompanie globalfield. If they are different the findcompaniecsript will run. I was so happy it worked. But I forgot something.
1. When I delete a companie. The fields will be different. And the script will run until I quit Filemaker.2. When I add a record the same thing will happend. It starts as fast as the fields are different. I found that this is not a good method.
Has anybody done this before. Im out of ideas.
PLS help
 
ASKER CERTIFIED SOLUTION
Avatar of Member_2_908359
Member_2_908359
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So, what was it exactly?
Avatar of perbackman
perbackman

ASKER

Hi,
I found an easy way to solve it. The script now only runs if the start position of the find field is an "-". I created a calculated field that puts an "-" befopre the companyname. I let the pull down field swow values from that. When the field gets that value it runs the script. In the end of the script I just delete tha value so that when the script end there is no "-" in the first left position. I was happy to find it out. Thanks anyway.
tricky indeed, but there must be a simpler way to do this; what if the purpose of doing this? to find only records from one company? Using a selfrelationship should do it as well and would be faster...
Wow. Now I understand what you mean. Ill try to do that. You are a way ahead of me.
Thanks