Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About dmontano

  • Rank

Profile Information

  • Gender
  • Location
    Southern California

Recent Profile Visitors

2,972 profile views
  1. Disregard this - I figured it out with a global field and a script trigger.
  2. I have a field configured with field validation - set to a maximum of 55 characters. I would like to display some visual feedback to the person entering data when they have exceeded this limit. Since the validation occurs after the field is exited, it's not very smooth throwing an error dialogue after they have typed beyond the limit. I am unable to provide visual feedback while they type. It would be helpful to display the text in black as the type while under the limit, and maybe display the overset portion in red text. Any techniques for this?
  3. eos, Thank you for taking the time to put this together. I am going to delve into this to try and understand it. Much appreciated!
  4. Hi eos, Two questions: ASSOCIATION EVENT would contain what type of records? Examples would be helpful. Would ASSOCIATION TYPE have records such as: synonymous, hyponymy, meronymy, etc.? As for scripting the Find, I did not know if FIleMaker provided what I was looking for via the creation of some sort of value list using a calculation, "native" function, or relationship technique that would prevent the creation of a script. If a script is the only way to provide the functionality, then I am learning as I go.
  5. From a User perspective, I can imagine a couple of scenarios: 1) They wish to search for what words have an association with other words. A drop-down list showing 1 instance of each unique word would indicate what words have an association. User selects drop down and sees CAR, they select it and takes them to any word association record, where a neighboring portal could display ALL other words associated with CAR. 2) User wishes to search for specific word, for example, CAR. They enter find mode, select CAR from drop-down and they would get the same experience whether they are browsing or se
  6. Hi all, Attached is a sample file that contains the problem I am trying to solve. In short, I would like a value list to display in FIND MODE all of the WORDS that have been used in creating WORD ASSOCIATIONS. The table is WORD ASSOCIATION: a WORD can be associated with another WORD. For example: CAR is associated with VEHICLE (a synonymous association). I have the "creation" of a WORD ASSOCIATION functioning. I also have drop down value lists in "find" mode for each of the two WORD fields functioning: they show only the values that exist within their respective fields. However, a User shoul
  7. Hi Comment, Sorry for the delay in saying thanks for your contribution. I like the idea of the GTRR. What I like most about it is it seems that it does not matter whether your relations are in a recursive single entity type table or separate entity type tables. Thanks
  8. Hi Comment, Apologies for not being clear. What I have so far: Database Structure: One table, "Category Type"; second table, "Category". Category Type is related to 1 or more Category(s). Category Type is recursive to provide the hierarchical structuring of Category Type(s). Likewise, Category is recursive to provide the hierarchical structuring of Category(s). I anticipate this will provide the ability to generate a text file of: the leaf node, the intermediary nodes, and the root node for 1 category. The directory folder structure will use the values from "Category", not "Cat
  9. Hi all, Â I need help. I am willing to pay someone who can build the script. Â I need a script that will work on Mac / PC that will generate a nested directory folder set from the records in my database. The nested directory folder set can reside on a users desktop after the script is finished executing for now. Â The records that are used for the directory folder names are related in a parent child arrangement in filemaker - so the hierarchy for these records exists. Each record will contain a text field that is to be used as the label for each directory folder created. Â I think
  10. Thanks Comment, I will build conditional value lists similar to the example file with fields in the OBJECT table to facilitate the "auxiliary" relationships. As for the globals route - I will toss that out based on your comment. And the "native" relationship magic I was hoping was hiding somewhere in the value list options is now off my wondering mind. However, your last statement has peaked my interest: Would you elaborate on this a bit?
  11. When creating conditional value lists - similar to the file provided by Comment above where the values for each drop-down are stored in separate tables — is it a requirement to store the foreign keys in the OBJECT table? It seems to me that the only purpose of creating the foreign key fields of "continent" and "country" in the OBJECT table is to facilitate the feature of providing a conditional value list. A few questions: 1) Is it possible to provide the conditional value list feature with global fields instead? Are there any downsides to doing so in a multi-user environment, or any
  12. Thanks Comment, appreciate your insight. I'm in the middle of trying to rework the database to accommodate what's been discussed.
  13. Hi Michael, My bad: the communication problem is mine. I am trying to build a classification application. This application needs to be able to manage all of the Categories, the Category Types in which Categories belong to, the way the Categories Rollup and the way the Category Types Rollup in a hierarchical manner. These would be all bound together in a particular Scheme. So far, I have a prototype that seems to be coming together reasonably well. The more I work with it, the more it is coming together, but it is a slow road. Two things are becoming more clear as I progress: 1) Creatin
  14. Ugh! I suspected there was some other issue underlying my problem. I am assuming that if I made the Scheme Version table, then to display the Scheme Versions that have the same Scheme Name… it becomes a simple matter of displaying a portal of the Scheme Version table on my Scheme layout. Which leads me to suspect that ALL of my current related child tables of Scheme (a good half-dozen) will require a retrofit. Are my assumptions correct?
  • Create New...

Important Information

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