Jump to content
Sign in to follow this  

ValueList from ExecuteSQL() based query in FMP 12

Recommended Posts

I'm looking into upgrading our FMP11 developed solution to FMP12. For us, key functionality exists around the ValueList feature to DISPLAY one value (e.g. a description) while RETURNING another value (e.g. a UID), into the selected field.

I would be interested if you have been able to replicate this feature from the ExecuteSQL() function (I can successfully return a single ValueList item ... having trouble with the above)

many thanks in advance Giles

Share this post

Link to post
Share on other sites

I don't think it will be possible to mimic this feature in FileMaker.

In my case there are two situations:

1. Key and related data is stored (for example in an invoice you want the key of the company and the name hardcoded)

In this case I have a SQL statement in the keyfield that will lookup the ID of the company when the company name changes

2. You don't store the related data

The entry field is only a global field, and with a script I set the key field to the correct ID. The display of the data I do via a webviewer (and also with a SQL statement)

My conclusion:

I don't like my approach as you have complete decentralized logic (if you want to update the value list, you often need to go to different places to update those as well), but it is the best I can come up with right now...

Share this post

Link to post
Share on other sites

Thanks for your reply. I'm going to continue my research. I really hope it's not the case that Filemaker add this significant functionality, but fail to implement it across such as base feature as ValueLists!

Share this post

Link to post
Share on other sites

Kevin Frank was so friendly to post a demo file on his website. I just created the file, the technique was demonstrated by John Ahn (mr_wodka) during an unconference session at DevCon.


Just a side note: I really loved the unconference sessions!

Share this post

Link to post
Share on other sites

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

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Oliver Reid 

Important Information

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