Jump to content

Auto Lookup (suggestions)?


schotja
 Share

This topic is 6276 days old. Please don't post here. Open a new topic instead.

Recommended Posts

So much new learning and was hoping to be pointed in the right direction.

How would one begin entering a company name (partial) and have it pull in a list of matches in the related portal?

FileMaker Version: 7

Platform: Windows 2000

Link to comment
Share on other sites

to match a partial name, you need a calc field in the related file with a multi-key value.

Smith would be:

S

Sm

Smi

Smit

Smith

You could do this using the left function

If you have FM 7 Developer, you can go to www.clevelandconsulting.com... their forums have a section on custom functions. There is a recursive function called Exploded Key that you can use to match an arbitrarily long string.

Link to comment
Share on other sites

Wow that was quick!!

I looked up the cleveland consulting link and am assuming since i don't have developer 7 yet that the exploded key is specific to that version. Seems very simple to use though.

Unfortunately i'll have to try to figure it out the old fasioned way.

Can you be a bit more specific on the calc?

Link to comment
Share on other sites

I was relentless and found a reference on the fmpro tips that was pretty detailed. Mirrored what i was trying to develop almost exactly. You must have seen the same one.

Anyone interested can do a search for clairvoyance!! Amazingly 1 hit!! Not hundreds to sift through!

Thanks for your help.....you pointed me in the right direction!

Link to comment
Share on other sites

  • 6 months later...

This topic is 6276 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.