Jump to content

Value List

Recommended Posts

Hello all,

I just started using FM17. It has been a long time, since FM11 that I have used FM. I am setting up a solution starting with FM Starting point. I created some value lists to use and all of them are fine but something strange keeps happening with one of them. I select the field, the options come up, I pick one, and I get this. "This operation could not be completed because the target is not part of a related table.". Filemaker does make the change when I select a new value from the list. How can I get this warning from a value list? Doesn't this error have to do with a script? I am not running a script that I can see.





Share this post

Link to post
Share on other sites

Hi Dave...

I think this is when the value list is tied to a relationship if the value list is to just show ALL values from another table than it wouldn't have that issue.

When the value list is defined to look up thru the relationship you will that value list will only work from the context of the layout where the relationship is valid.


Share this post

Link to post
Share on other sites

Long time no see. This is a value list with custom values. Not tied to any table. That is what is so strange. I have two on the page. One works fine, one does what I am talking about. I'll recheck it



I deleted the field on the layout. Made one on the layout again, and it fixed it. Must have had something tied to it from ther starter solution template.





Share this post

Link to post
Share on other sites
Posted (edited)
19 hours ago, faaslave said:

"This operation could not be completed because the target is not part of a related table."

This message comes up when you have a script trying to perform some action (e.g. set a field or go to related record) without having a relationship to the target of that action.

It also appears  if you place a field from an unrelated TO on the layout, then try to edit the value in that field manually.

Most likely, the field you have deleted had a script trigger attached to it. And you probably copied it from another layout, where the script was in the proper context for the action to take place. 

Bottom line, you must be very careful when modifying an existing solution made by someone else.



Edited by comment
  • Like 1

Share this post

Link to post
Share on other sites

That is exactly what happened. Thanks Comment. Glad to see you are still on here


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

  • Similar Content

    • By Eli Walker
      I'm working on a set of FM solutions that all share data links between one another. Currently, I'm working on local versions of the files but eventually the solutions will be uploaded to FM Server. Is there anyway that I can upload all of these solutions at once without breaking their links to one another? Or is it best I just build those links after the solutions are uploaded to FM Server?
    • By gczychi
      we're using Rest API and we are not using FileMaker web hosting. Therefore, a landing page like «FileMaker Database Server Website» doesn’t make sense for us (looks a little bit like the Boston T in blue). Better would be to redirect a user to the company website, which resides on another server and has another subdomain.
      I’m not sure where we could change that, but it may be something like:
      Redirect all requests for FileMaker’s landing page, which are not for port 443 OR does NOT contain the string "/fmi/data/v1/databases/DATABASE/sessions" to "www.anotherwebsite.com:80".
      Other services, like ssh, vnc, should not be affected.
      Where and how would something like this be configured?
      A good new year to you all,

    • By Hijack
      Maybe it's just our enterprise's network but our FM clients never seem to reconnect on a loss of network (wifi, wired, VPN, anything).  We always get the endless "Reconnecting..." dialog on the fat client even on the shortest of disconnects and phantom disconnects where the network link is never truly lost.  Go clients seem happy as a clam to reconnect in almost any scenario though. 
      Anyone have a suggestion on what to look at to try and improve this?
    • By DBPhoto

      I saw that Filemaker is running a buy one get one free deal on FM17 for another few weeks and was wondering if anyone is interested in going in 50/50? 

      If you are please email me at daniel(at)danielbedell.com
    • By jjjjp
      I have been using FM Pro on FM Server 13 since 2014 to organize a multi-college series of workshops with a handful of colleagues at other colleges in my university. The database is essential to our operation, but the number of users other than me needing to access it at any time is quite minimal. I must upgrade Server because my colleagues have upgraded to FM Pro 16 for a different, much larger operation that runs out of a different academic unit. FM Pro 16 isn't compatible with FM Server 13. Unfortunately, I can no longer easily purchase a standalone version of Server. The new cost of running Server is going to average to about 10 times the cost over the last four years. The rep at Filemaker suggested that I share some other unit's version of FM at my university.
      Is there an easy way to upload and download a database to the administrative console without needing to ask for direct access to the console? I will need to propose an arrangement that doesn't give me administrative access to other databases on the console. But I will also need to be able to replace the current version of my database at any time without having to call on somebody else with the necessary privileges. Perhaps there are scripts that do this for either Mac or Windows platforms? Or, even better, does FM Server offer a simple way of providing limited access?

Important Information

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