Weatherid
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 9 articles for 0.302 sec
Here are the latest links on alt.comp.freeware [OT] Developers - $10M Challenge Extended to April 14, 2008 http://code.google.com/android/adc.html http://tinyurl.com/38qpt9 http://www.eenvandaag.nl/stemwijzerusa/en/ www.collectibles.fyis.org [Update] PDF-XChange Viewer 1.0.34 http://www.docu-track.com/home/prod_user/PDF-XChange_Tools/pdfx_viewer/history http://www.docu     

Group: alt.comp.freeware · Group Profile · Search for Weatherid in alt.comp.freeware
Author: Mark Carter
Date: Feb 1, 2008 02:20

Craig wrote: bealoid wrote: Craig <netburgher@REMOVEgmail.com> wrote in news:_z7oj.3767$nK5.2139@nlpi069.nbdc.sbc.com: </RANT-ON> Cell phones are just so frustratingly "locked;" to carriers; to closed OSes; to proprietary apps. ARRRGH. Is it too much to ask to have a transparent data-portability proposition? Considering it's our bloody data??? </RANT-OFF
Show full article (5.02Kb)
On Mon, 17 Dec 2007 16:05:54 -0700, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote: >On Mon, 17 Dec 2007 13:08:47 -0800, croy <croy@invalid.net> wrote: > >>SELECT tblIvSurv.*, tblGeoLoc.GeoLocName, >>tblGeoLoc.GeoLocDE, tblWeather.WeatherDescr, >>IIf(Weekday([SurveyDate])=1 Or >>Weekday([SurveyDate])=7,"1","2") AS WkEnd >>FROM tblWeather RIGHT JOIN (tblGeoLoc INNER JOIN tblIvSurv     

Group: alt.comp.freeware · Group Profile · Search for Weatherid in alt.comp.freeware
Author: Susan Bugher
Date: Jan 31, 2008 12:05

No. You would use the relationship between section and reach if you wanted to filter by reach. You could store reachID and SectionID in the progress table if that makes more sense to you but it is unnecessary and technically a violation of second normal form. Having a foreign key to Section from Progress automatically gets you to Reach if you include the Reach table in the join. "Andy
Show full article (2.53Kb) · Show article thread
No. You would use the relationship between section and reach if you wanted to filter by reach. You could store reachID and SectionID in the progress table if that makes more sense to you but it is unnecessary and technically a violation of second normal form. Having a foreign key to Section from Progress automatically gets you to Reach if you include the Reach table in the join. "Andy     

Group: microsoft.public.access.queries · Group Profile · Search for Weatherid in microsoft.public.access.queries
Author: croy
Date: Dec 18, 2007 06:57

Thanks for the advice I'm sure you are right but... (bear with me) The reason progress and reach are linked is because the reach dictates which sections are "available" to progress as the reach seletion filters the available sections. If I do what you say won't I loose the ability to filter as above? I appreciate your help Andy "Public" <please no email@aol.com> wrote in message
Show full article (1.84Kb)
Thanks for the advice I'm sure you are right but... (bear with me) The reason progress and reach are linked is because the reach dictates which sections are "available" to progress as the reach seletion filters the available sections. If I do what you say won't I loose the ability to filter as above? I appreciate your help Andy "Public" <please no email@aol.com> wrote in message     

Group: microsoft.public.access · Group Profile · Search for Weatherid in microsoft.public.access
Author: Public
Date: Feb 7, 2007 11:16

I think 1 is correct EXCEPT that you have the relationship backwards. SectionID should go in the progress table rather than ProgressID going in the section table and ReachID should be removed from tblProgress. Progress is your daily report and you want to report which sections you worked on which days. tblProgress should be: ProgressID SurveyDate TeamID WeatherID SectionID Comments
Show full article (3.21Kb)
I think 1 is correct EXCEPT that you have the relationship backwards. SectionID should go in the progress table rather than ProgressID going in the section table and ReachID should be removed from tblProgress. Progress is your daily report and you want to report which sections you worked on which days. tblProgress should be: ProgressID SurveyDate TeamID WeatherID SectionID Comments     

Group: microsoft.public.access.tablesdbdesign · Group Profile · Search for Weatherid in microsoft.public.access.tablesdbdesign
Author: Public
Date: Feb 7, 2007 11:16

Show full article (3.21Kb)
    

Group: microsoft.public.access · Group Profile · Search for Weatherid in microsoft.public.access
Author: Andy Roberts
Date: Feb 7, 2007 11:06

Show full article (2.63Kb)
    

Group: microsoft.public.access.tablesdbdesign · Group Profile · Search for Weatherid in microsoft.public.access.tablesdbdesign
Author: Andy Roberts
Date: Feb 7, 2007 11:06

Show full article (2.63Kb)
    

Group: microsoft.public.access · Group Profile · Search for Weatherid in microsoft.public.access
Author: Public
Date: Feb 7, 2007 10:56

Show full article (2.13Kb) · Show article thread
    

Group: microsoft.public.access.tablesdbdesign · Group Profile · Search for Weatherid in microsoft.public.access.tablesdbdesign
Author: Public
Date: Feb 7, 2007 10:56

Show full article (2.13Kb) · Show article thread