Re: multiple field "or" criteria

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JulieD (julied_ng_at_hctsReMoVeThIs.net.au)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 09:17:33 +0800

Hi nd

i've downloaded your normalized.mdb and am having a look in the
relationships window - from the menu tools / relationships - add all your
tables, in a "well constructed" database you would expect to see joins (ie
the relationships) between the tables with a 1 & infinity symbol on them
(meaning that they're related and have referential integrity enabled).

there's a bit of work to do to get your database's structure "correct" and
i'm happy to help you sort this out but would rather assist you in reaching
your goal then doing it for you so if you would like to work together on
this a starting point would be reading of a pdf i have on my website
http://www.hcts.net.au/tipsandtricks.htm
called "Creating a Database - The Basics"
and outline what you think needs to happen and then we can look at
implementing the changes necessary.

If however, you'ld rather i just sorted it out for you please post back and
let me know.

Cheers
JulieD

"nd" <thebesthorizon@hotmail.com> wrote in message
news:Xns94BDA2284BCAFthebesthorizonhotmai@208.33.61.208...
> **** Post for FREE via your newsreader at post.usenet.com ****
>
>
>
> my db's are on the web - my instructorinfo table is the "master table"
that
> i guess is unnormalized - any help appreciated
>
> http://www.pfll.org/dbtesting/
>
> thanx
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.usenet.com
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Relevant Pages

  • Re: Primary Key not sorted
    ... Are you willing to rely on any "natural" sort of records? ... > though the Company field is the Primary Key but if I ... When I Compact and Repair the database it ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Data sorting for print job
    ... Hence if they pick the second data field then it will sort on this ... 1] is a database the best way or are there alternatives such as ... Access is not bad as a desktop database. ... OTOH, relational database management systems usually are more ...
    (borland.public.delphi.database.ado)
  • Re: WHY
    ... >it would be GROSSLY inefficient to do sorting on 100 different machines ... each of these phones has had to sort the same numbers ... table or an OLAP cube but in an array in memory having just been calculated ... it's way to a database, but it'd be read and used in calculations prior to ...
    (microsoft.public.excel)
  • Re: Microsoft ACCESS orderby case insensitive
    ... Sorry for that because I've always been working on the Oracle database, ... sort many fields not only one, depends on which field user clicks. ... "Duane Hookom" wrote: ... Is there a simple way to sort in case insensitvie? ...
    (microsoft.public.access.forms)
  • Re: sorter script [was: Frustrated newbie question]
    ... was from the "perldoc -q sort" as a way of ... most 'elegant' of looking algorithms. ... that bogged the database engine down. ... was due to bad implementation on the db engine. ...
    (perl.beginners)