Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About HarrisonM

  • Rank
  1. Not sure how that will help me if it worked for you? Anyway, here is screen capture of the error it shows upon submitting the form to proceed to download. Tested on Firefox 14, Chrome. Chrome just reloads the page, firefox shows the error. :hmm:
  2. OK, I get it after going through the attached fp7 file. Thank you very much. Case closed :)
  3. Thank you very much for pointing out that article. That article says "In version 9, a field used to match a Number field in a ≠ relationship is considered empty, unless it has an actual number in it." The match fields in my case cSelectedTags and Article_TAGS_forVLunselectedTags::TagID are text fields. Does this mean that I have to use the Serial# field rather than the TagID text field (which is actually an autoenter calculation = SerialIncrement("TAG000000";Serial#). So updated the calculated field with a fictitious tagID "TAG99999999" to be appended to the top of the cSelectedTags
  4. For a database for articles, Each article has multiple tags. I have a basic setup with a portal showing records from the join table between Articles and Tags. I am trying to create a value list for tags that updates itself showing only unselected tags for an article. ARTICLES::cSelectedTags is a calculation=List(ARTICLE_TAGS::TagID_fk)&¶ Then ARTICLES::cSelectedTags is connected to a duplicate TO of TAGS::TagID using a not equal relationship operator. A value list is built using this relationship, would exclude the tags selected in the portal ? Attached images show the relation
  5. The link is not working. Fatal error ! Uncaught exception! :hmm:
  6. Thank for the help really. The suggestion would have been useful for us "non-experts in filemaker" if you could explain the "insecurity" in the process. So.. does it mean that restricting access with filemaker privileges is not good enough to deter hackers ? A similar database solution made in MS-SQL in the university has the admin able to upgrade or downgrade user privileges this way. Why would a similar process in filemaker be insecure? Luckily, My humble solution runs on our local computer and is used to log in students into a CBT solution so we can track their performance durin
  7. Got it figured with some trial and error. Mods may save space by deleting the original post. Cheers
  8. In my Filemaker solution, I have 2 types of users. Students and Teachers. I have made a login script that checks a users table for the username and password. The plan was to record in the users table, an admin approved name for a privilege set: Students get "Read only access" and Teachers get "Data Entry Access" My questions are: In order for a user to login as a "Student", Should I 1. Manually create a filemaker account called "Student" with [Read-only-Access] and then using the script step "Re-login" using the account "Student" ? OR 2. If the username and passw
  9. cool ! for the links. Thanks to eos for explaining that cartesian query. But AllTags actually gets a return separated list of all tag names using the cartesian query. Don't know how that works for me. Anyway the link "comment" posted clarifies how to excluding value lists. Thanks again.
  10. Articles to tags in a database has a many to many relationship. I am using a portal to add tags to an article. How do I create a dropdown list that dynamically removes tag entries already added by the user. Say if the taglist contains "Applescript, bash, ruby, Filemaker" and if the user selects "Filemaker" for Article1 and when trying to add a new tag to Article1 the value list shows only "Applescript, bash, ruby" and so on.. Logic was that if I could connect a return separated list of userSelectedTags from the parent table to a return separated list of all TagNames in the child table usi
  • Create New...

Important Information

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