Results 1 to 11 of 11
  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Unanswered: 3 cottages, 1 booking?

    hello,
    firstly may i apologise for any part of my message that may come accross as ignorant or just plain stupid.
    I am a novice db user and was just wondering, I am trying to create a similar db to the one mentioned above, with the three tables for cottage, customer and booking.
    Does the above code listing allow for 1 booking entity to reference more than one cottage
    eg. booking reference 1: books cottage 1,2,3 for a particular customer on particular dates.

    that is what i am trying to achieve and i am struggling to get my head around the whole concept, any advice on topics i should study in more detail would be much appreciated.

    This is my first ever forum post, be gentle!!

    thank you

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Welcome to the wonderful world of forums!

    If booking and cottage have a one to many relationship, then you can have any number of bookings per cottage.

    BTW, it might be simpler if you start a new topic on this... not sure yet... but you may not need to code this... if you are using Access you can just create the tables using Design rather than do it using SQL statements.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Movification complete.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Not so clever there poots, coz now you've made post 1 here confusing in what he's referring to with "mentioned above" and "above code listing"

    I dunno, the n00b mods we have here!! :whistle: :nudge:

    [sarcasm]Oh hell, where's them tags george needs[/sarcasm]

    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Typical Aussie. If this board was not rammed to the rafters with hopeless users trying to get one over us humble, hard working mods things would run a lot more smoothly.
    Quote Originally Posted by StarTrekker
    Crikey! That flamin' galah has only forgotten to link back to the original thread. Should I.... nah - I'll rip into TALCPOOF III fair dinkum. You little bewdy ST!
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hmmm. Can't actually find the original thread. Anyone fancy helping out?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by StarTrekker
    [sarcasm]Oh hell, where's them tags george needs[/sarcasm]
    Nice to find someone following correct forum ettiquette!
    George
    Home | Blog

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by pootle flump
    Typical Aussie. If this board was not rammed to the rafters with hopeless users trying to get one over us humble, hard working mods things would run a lot more smoothly.
    Quote Originally Posted by pootle flump
    Hmmm. Can't actually find the original thread. Anyone fancy helping out?
    ROFLMAO!!!!!!!!!!!!!!!

    Face it, you're owned
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by i_rosser
    hello,
    firstly may i apologise for any part of my message that may come accross as ignorant or just plain stupid.
    Stop. You had me at "hello".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    In all seriousness...

    i_rosser, I'm afraid that your post was made in to a new thread, and the link to the original has been severed. If you know the original link, please post back and we'll merge the information appropriately.
    George
    Home | Blog

  11. #11
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The code being referred to was just three MAKE TABLE definition statements which would create the three tables mentioned.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •