| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
10-27-08, 18:20
|
|
Registered User
|
|
Join Date: Oct 2008
Posts: 1
|
|
|
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
|
|
10-27-08, 21:38
|
|
L33t Helpa Munky
|
|
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
|
|
10-28-08, 04:07
|
|
King of Understatement
|
|
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
|
|
|
|
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
|
|
|
10-28-08, 08:04
|
|
L33t Helpa Munky
|
|
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
|
|
10-28-08, 08:56
|
|
King of Understatement
|
|
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
|
|
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:
Quote:
pootle flump
ur codings are working excelent.
|
|
|
10-28-08, 09:00
|
|
King of Understatement
|
|
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
|
|
Hmmm. Can't actually find the original thread. Anyone fancy helping out?
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
|
|
|
10-28-08, 09:11
|
|
www.gvee.co.uk
|
|
Join Date: Jan 2007
Location: UK
Posts: 10,156
|
|
Quote:
|
Originally Posted by StarTrekker
[sarcasm]Oh hell, where's them tags george needs[/sarcasm]
|
Nice to find someone following correct forum ettiquette! 
|
|
10-28-08, 09:50
|
|
L33t Helpa Munky
|
|
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
|
|
10-28-08, 13:04
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
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"
|
|
10-28-08, 13:17
|
|
www.gvee.co.uk
|
|
Join Date: Jan 2007
Location: UK
Posts: 10,156
|
|
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.
|
|
10-28-08, 22:00
|
|
L33t Helpa Munky
|
|
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
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
3 cottages, 1 booking?
