Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Transitions

  • Rank
  1. I've now read quite a bit on occurrences, and I understand "how" to create them, but curious to understand the "why". If I drag a link between two tables, I know that creates a single-criteria relationship, and if I drag two links between two tables, it creates a multi-criteria relationship, which creates an AND situation. Is an occurrence link like the one on you created an OR rather than an AND or something completely different? Thanks.
  2. On the second question, I see the relationship and understand the fact that the value list is displaying information from two fields in "Matching Modules", but can't see where the "Matching Modules" table is generated from (and why it's purple in the relationship) as "Define Database" tables only shows two tables: "Module" and "Contracts". Is there some black magic going on here that creates a third table without having it actually appear as a table under "Define Database"?
  3. Hi Comment, Thanks for the reply and example; yes, your example is the route I'm trying to go. I noticed if I check off one of the module types (ie, "waxing") and the choose a moduleID with that name, then uncheck the same module type from the checkbox, that the ModuleID changes to a number and the Description retains the words of the previously chosen ModuleID's description. What I'd been able to do was force the ModuleID back to "None" and have it drop the description words. Am I stuck with an "either / or" scenario? Also, quite curious to know how your duplicate table "Match
  4. Hi Comment, The contract is allowed to have only one module, but the choices can come from any of the modules that match the chosen checkbox(es) criteria. Let me use another analogy what I'm trying to accomplish: a hypothetical "game of chance" database. This db has two tables "modules" and "choice" (in lieu of contract). The "modules" table has "modules" which are essentially numbers and letters with the module type tacked on as a prefix. One "module" type might be called "1digit", one might be called "2digits" and one might be called "alphabet". So, under the module ty
  5. Hi Comment, Thanks for the reply. I'm trying to understand the difference between what Mikhail did in his example and what I'm trying to do. He was able to get a radio button choice to filter / display records that contained the word for the radio button choice. I'm trying to do the same thing but using a checkbox, so that one or more of the boxes could be checked, allowing records that contain the one or more words from the checkbox to then be displayed as options for the user to make a single choice from. Don't think I need a table, as the user would only get to choose one module,
  6. Hi, thanks for the reply. Mikhail changed it to a radio button (ie, only one could be selected at a time). When I tried to use his example against my original request (to have a checkbox that would allow me to choose one or more than one checkbox and then filter or display only the modules that contained the word for each checkbox) his example didn't work, as it was based on showing only related records for one choice. I then put together a second example file that I hoped would be a bit more explanatory (named ExamplePost2.fp7) which is in my response after his posting. Hope
  7. Thanks - maybe I was making my example too complex for one set of choices. The reason I was using the checkbox, though, was to add multiple module names. Should I approach multiple module names (on your "Contract" table in the example) via the way you allowed multiple selections on the "Linked Fields" Sample 2 database (from your great blog) or should I go back to trying to use a filter calculation? I'm attaching another example db here to show what I'm using the choices in the checkbox to generate (a calculation that takes text written in a module body and applies "merge expression
  8. Here's the example. Note that all the module options show up in the drop-down menu whenever any box in the checkbox is checked. Just trying to figure out how to get those that contain the word that's been check in the checkbox to show up in the drop-down menu. Thanks. ExamplePost.fp7.zip
  9. I am trying to understand whether to use the filter function in a calculation. Here's the scenario: I have one table called AllModules. This field contains four text fields: ModuleName, ModuleType, ModuleBody and ModuleID. The latter is concatenated from ModuleType and Module Name (ie, Module Name might be "Weekly" and ModuleType might be "Cleaning", so ModuleID would be "CleaningWeekly"). ModuleBody contains text that describes the ModuleName (ie, "This is a weekly cleaning module . . . ") One a separate related table (related via ModuleID) I have a text field called CheckboxField t
  • Create New...

Important Information

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