Search results

  1. Ani

    Understanding 2NF & 3NF?

    G'Night! And Good Luck! Ani
  2. Ani

    Understanding 2NF & 3NF?

    Oh...more reading!:D
  3. Ani

    List of Cities for UK in Lookup, please?

    Thanks. I dont have many customers right now and most are local, so it shouldnt be a problem! Ani
  4. Ani

    Thought processes - still planning things

    Oh...I was thinking white square but knew that wasnt correct! Ani
  5. Ani

    Understanding 2NF & 3NF?

    :eek::eek::eek::eek::eek::eek::eek: LOL
  6. Ani

    Thought processes - still planning things

    I dont think I can work this one out. There isnt an opposite colour for black or for ball. There is only an opposite meaning for the phrase. I think you will have to tell me...please? Ani:confused:
  7. Ani

    List of Cities for UK in Lookup, please?

    Oh crap! Good job I asked, I forgot that I needed the option for rural address. As most of my customers will be in rural areas I shouldnt have forgotten! I do understand the difference between Postal Town and Town but only because it is irksome to me! I think even the RM are confused about...
  8. Ani

    Thought processes - still planning things

    That sounds vaguely familiar, but I thought it was WWII?? Yes I have been to Coventry but only briefly, a couple of times for interviews and once because I came off the motorway at the wrong junction! I think every place has its drawbacks and you can find good and bad people wherever you go. In...
  9. Ani

    Thought processes - still planning things

    Errrrm...I know a black ball is associated with (secretly) voting someone out or off, to 'black ball' someone is to make them unwelcome, to ostracise them or "send them to Coventry". A white ball is used as an affirmative vote, so presumably is the opposite? I have no idea where the phrase "send...
  10. Ani

    List of Cities for UK in Lookup, please?

    Hi Guys I have posted this in General because I dont actually know where I should look or ask about this. I have created a form for CustomerDetails via a query. As the entries such as Area, Town/City will be repeating data I believe I should have a lookup on the query. Do I have to manually...
  11. Ani

    Understanding 2NF & 3NF?

    Cheers Rain! I may be over thinking but I would much rather understand than just 'do'! I dont even want to think about 'code', not sure I will ever get that far. Ani :)
  12. Ani

    Thought processes - still planning things

    Hi Rain I hope you have enjoyed your holiday? Thanks for displaying the Relationship window that way. I can see how it is all connected now. Ive read through the stuff on normalisation again and looked at the tables. There were a couple of minor errors still, a - in one of the names, cant...
  13. Ani

    Understanding 2NF & 3NF?

    Oh NO! I feel like a proper idiot now! I missed the obvious didnt I! We have to restore the relationship by creating something called a foreign key (indicated in our diagram by (FK)) in the orders table. The important bit! A foreign key is essentially a column that points to the primary key in...
  14. Ani

    Understanding 2NF & 3NF?

    Hi Guys Im getting lots of help which I really appreciate but I am trying to properly understand 3NF. Ive read Alans Relational DB link and looked at A Langers tutorials. TBH his tutorials confuse me! This is the clearest description of 3NF to me "Then, to be in 3NF, a table must be in 2NF, and...
  15. Ani

    Thought processes - still planning things

    Ok, I dont have an awful lot of time right now, 6yr old to get sorted with her pony and hopefully get to bed at a reasonable time! First thoughts How do we 'know' anything? Define 'know'. According to the Cambridge dictionary, 'Know' means "to have information in your mind". People forget that...
  16. Ani

    Thought processes - still planning things

    Oh LOL.... Thank you...I wasnt expecting it now. Please go and get some sleep or you wont enjoy your Queens holiday day! ;) Ani
  17. Ani

    Thought processes - still planning things

    Oh...I will miss the comments! :D
  18. Ani

    Thought processes - still planning things

    OK, will sort! Thank you. We had our Queens holiday last Monday and Tuesday for the Jubilee. Im not much of a Royalist but the holidays are appreciated! G'Night Ani
  19. Ani

    Thought processes - still planning things

    Oh....:)! I have never studied any type of philosophy as I find the whole area somewhat daunting. I am however interested, as long as I dont actually have to apply it to real people. I find Humans most difficult to understand! Ani PS I dont mind admitting I dont understand something, how...
  20. Ani

    Thought processes - still planning things

    Ok, here goes...I am braced for the next set of challenges!:D Database Notes 10-6-12 Changes since 3-6-12 As suggested: Special characters removed from field names (eg &, /, (), -) Data Types checked on Table fields Lookups removed from Tables – some notes in the description fields as to where...
Back
Top Bottom