Peter Ardis Posted May 26, 2009 Share Posted May 26, 2009 For Educational Context. Two Tables. SpellingWords and SpellingLesson. SpellingWords stores as records all the Spelling Words and related data. This table has fields for Word, Definition and WordType (noun, verb etc.). In the SpellingLesson table I type a word, i.e. "light", and a SpellingWord portal shows the information for the specific word. My portal has a scroll bar so that the definition for "light" (i.e. not heavy) show up as well as the definition for light (i.e. not dark). The Problem: I need to be able to bring only one specific definition that I select from SpellingWords onto the SpellingLesson Table in order to create a lesson with it and I cannot figure out how to select a specific portal row (i.e. not heavy) and make that data available in the SpellingLesson. I have tried buttons on the portal row, but cannot get the script right. If the word has only one context/meaning such as "luddite" SpellingLesson table currently works fine. This seems like it should be quite simple. Thanks in advance for you help. Link to comment Share on other sites More sharing options...
AHunter3 Posted May 26, 2009 Share Posted May 26, 2009 By "select" do you mean "in a script", i.e., literally GO TO a portal row and cause it to be the active portal row and then set other fields or parameters to its vaue? Or do you mean "within calculations or relationships", e.g., creating references within your structural definitions that reference a specific portal row? In other words, verb or noun? Link to comment Share on other sites More sharing options...
Peter Ardis Posted May 26, 2009 Author Share Posted May 26, 2009 I want to "... cause it to be the active portal row and then set other fields or parameters to its value". I will need to browse/scroll the portal rows that occur when I type "light" in SpellingLesson::Word. When I see the word that I want in SpellingWords portal, I want to be able to select a specific record/word/portal row and cause it to be part of the Lesson. For example make the definition in SpellingWords "light" (i.e. not heavy) become the active definition in the Definition field in the SpellingLesson. Hope this makes sense. Link to comment Share on other sites More sharing options...
AHunter3 Posted May 26, 2009 Share Posted May 26, 2009 So it will include user intervention ("user" meaning YOU)? As in YOU PICK which portal row is the relevant one? I'd stick a button in the portal row itself; it should do something like this: Set Field [Lesson::Definition; PortalTable::Definition] When you click on it, the specific portal row for PortalTable::Definition is the one that you click on. That is, you will see the button over and over again, once per portal row, and it "knows" which portal row's "copy" of the button you clicked on. Link to comment Share on other sites More sharing options...
Peter Ardis Posted May 26, 2009 Author Share Posted May 26, 2009 Where does the "Set Field [ Lesson::Definition; PortalTable::Definition " go? As part of a Case calculation in a script? If it is part of the script for the button field, what is the field that I specify? I assume the definition in the lesson table. I have tried a few things but nothing yet. Link to comment Share on other sites More sharing options...
Peter Ardis Posted May 26, 2009 Author Share Posted May 26, 2009 (PS The smilies are not intended.) Link to comment Share on other sites More sharing options...
AHunter3 Posted May 26, 2009 Share Posted May 26, 2009 This is a button-function, or a single-step script assigned to your portal's button: Set Field [Lesson::Definition; PortalTable::Definition] (PS The smilies are not intended.) there's a checkbox in "Advanced" post on this board that lets you disable smilies Link to comment Share on other sites More sharing options...
kirkrr Posted May 26, 2009 Share Posted May 26, 2009 This is a button-function, or a single-step script assigned to your portal's button: Set Field [Lesson::Definition; PortalTable::Definition] there's a checkbox in "Advanced" post on this board that lets you disable smilies Allan - I think smiley-undecided the question was "what does the "set field" do in this case? Oh Really! Ahunter is suggesting a command that takes the field content from the portal field called "Definition", and writes it to the lesson field named "Definition". Link to comment Share on other sites More sharing options...
AHunter3 Posted May 26, 2009 Share Posted May 26, 2009 Yes, sorry. I assumed someone with "Intermediate" skills knew what Set Field does! I'm afraid that sometimes when I describe something, because HECK, I know what I'm referring to, I don't realize it isn't self-explanatory to the folks I'm conversing with. Link to comment Share on other sites More sharing options...
Peter Ardis Posted May 27, 2009 Author Share Posted May 27, 2009 Okay I got it. Thanks. A very useful tool, if I only had have known about how the set field works I could have saved myself hours. Now to rewrite the database.... What I did not know was that the first definition field referred to the Specify option and the second definition referred to the Calculation option. That is what I meant by where does it go? I will down grade my level from "intermediate" to "loser". Truly thankful. Link to comment Share on other sites More sharing options...
HBMarlowe Posted May 27, 2009 Share Posted May 27, 2009 I will down grade my level from "intermediate" to "loser". How about "up and coming"?smiley-wink Link to comment Share on other sites More sharing options...
AHunter3 Posted May 27, 2009 Share Posted May 27, 2009 I will down grade my level from "intermediate" to "loser". And I, in turn, will take a refresher course in Tact Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts