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.
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.
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.