Newbies Danshan Posted October 22, 2007 Newbies Share Posted October 22, 2007 (edited) I have two repeating fields, Term, and Win. Win is a pop up field with only one value, "X". I have a non-repeating field, Win Term. I am simply trying, upon entering "X" in the Win Field to have the contents of the corresponding Term field placed in the Win Term Field. Have used the Extend Function but am missing something-can only get the first Term value. Would really appreciate some help. Thanks. Term Win 24 36 48 60 Term Win ? Edited October 22, 2007 by Guest Link to comment Share on other sites More sharing options...
Raybaudi Posted October 22, 2007 Share Posted October 22, 2007 Hi it's possible to do what you want... ... but why not use a simpler checkbox set instead of two repeating fields ? Link to comment Share on other sites More sharing options...
Newbies Danshan Posted October 22, 2007 Author Newbies Share Posted October 22, 2007 (edited) The field, Term, must be repeating as I bid jobs with different terms, but will only win one of the terms. I will use the winning term in other calculations if it is selected with an X. I could use a checkbox set, but I'm not sure its any easier. In one case the checkbox would be "x" or blank, in the pop up box its either "x" or blank. Thanks for your help. Edited October 22, 2007 by Guest Link to comment Share on other sites More sharing options...
Søren Dyhr Posted October 22, 2007 Share Posted October 22, 2007 Term, must be repeating as I bid jobs with different terms, but will only win one of the terms Hopefully are you aware of the violation of relational principle's here - it would be beneficial to know whether or not is done deliberately?? Jobs in plural seems more obviously broken out as tablename as in a separate table. But why is this task being thrown after a releational database, in the first place, when "flattening" hardly ever, if at all?? Does anything to flatter the gist of the tool. --sd Link to comment Share on other sites More sharing options...
Newbies Danshan Posted October 22, 2007 Author Newbies Share Posted October 22, 2007 I am not intentionally trying to violate anything. I just simply want to have information in a repeating field show up in a non repeating field if another repeating field contains "x". If this is a violation of a relational principle, perhaps I should have another work around. I wanted the defined term to look something like "extend(if(Win="x";Term,""))" Perhaps this can't be done. Thanks for your help. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted October 22, 2007 Share Posted October 22, 2007 Of course it could be done! Similar could Dan Acroyds way of parallel parking in Bluesbrothers with the timed appropriate pull in the handbrake, but more convenient methods exists. Similar do you have to take the deficiencies you impose on the data structure by utilizing repaters into the equation as well. Instead would I urge you to explain why it isn't considered worth the efford to break data out into, say a portal. You descripe yourself as novice, and as such do you need to hessitate the desire to flush repeaters all over the solution. Repeaters are cool for utility purposes, but when using them for storing data are you painting yourself into a corner. Multi valued fields are nowhere in the database world really embraced ...first normalform deals exactly with this as the most important issue to solve. --sd Link to comment Share on other sites More sharing options...
Newbies Danshan Posted October 22, 2007 Author Newbies Share Posted October 22, 2007 Thanks for your help. I'll look for another solution. Link to comment Share on other sites More sharing options...
Vaughan Posted October 22, 2007 Share Posted October 22, 2007 Soren wrote: "Dan Acroyds way of parallel parking in Bluesbrothers" So that's it: Soren is on a Mission From God. Now it all makes sense. :) Link to comment Share on other sites More sharing options...
Genx Posted October 22, 2007 Share Posted October 22, 2007 LOL Link to comment Share on other sites More sharing options...
Søren Dyhr Posted October 23, 2007 Share Posted October 23, 2007 Doesn't gods usually issue doctrines though profets, instead of replying questions with other questions? --sd Link to comment Share on other sites More sharing options...
Lee Smith Posted October 23, 2007 Share Posted October 23, 2007 Doesn't gods usually issue doctrines though profets, instead of replying questions with other questions? --sd and don't you mean "prophets" BTW, you used the quick post [color:red]again Link to comment Share on other sites More sharing options...
Søren Dyhr Posted October 23, 2007 Share Posted October 23, 2007 ;) I did sorry ...and yes the spelling is a too danish, where the "ph" as "f" hardly ever get used! --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6121 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now