Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Question on example plug-in.

Posted on 2006-04-14
Medium Priority
Last Modified: 2010-04-27
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
Question by:perbackman
  • 3
  • 2
LVL 28

Accepted Solution

lesouef earned 750 total points
ID: 16458293
it is probably because yr script has a loop from which it cannot exit. you should modify the delete script to change the global field content to the value of the current record after deletion. and when you add a new one, you should set the global field to be the same as the last record created.
LVL 28

Expert Comment

ID: 16459848
So, what was it exactly?

Author Comment

ID: 16461766
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.
LVL 28

Expert Comment

ID: 16461803
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...

Author Comment

ID: 16461878
Wow. Now I understand what you mean. Ill try to do that. You are a way ahead of me.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question