Re: [sqlite] newbie question about laying out a simple database for bookings

2008-04-10 Thread sqlfan
Dennis Cote wrote: sqlfan wrote: I'm booking five resources, and right now I just use an excel sheet with all the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five columns are the five resources. When I book one, I just scroll to the appropriate date and change the

Re: [sqlite] newbie question about laying out a simple database for bookings

2008-04-10 Thread Dennis Cote
sqlfan wrote: Thank you so so so so so so so much So much. Even when I have your code in front of me, it's still very very hard for me to understand it. This is hard stuff! So much harder than a spreadsheet, but hopefully it will work out in the end, because I'm programming in

Re: [sqlite] newbie question about laying out a simple database for bookings

2008-04-07 Thread P Kishor
On 4/7/08, sqlfan [EMAIL PROTECTED] wrote: I'm booking five resources, and right now I just use an excel sheet with all the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five columns are the five resources. When I book one, I just scroll to the appropriate date and

Re: [sqlite] newbie question about laying out a simple database for bookings

2008-04-07 Thread Dennis Cote
sqlfan wrote: I'm booking five resources, and right now I just use an excel sheet with all the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five columns are the five resources. When I book one, I just scroll to the appropriate date and change the color of the column for

Re: [sqlite] newbie question about laying out a simple database for bookings

2008-04-07 Thread sqlfan
I guess I fit in the more ambitious category then. I hope my workload will increase at any rate. Anyway I've looked at some tutorials, but I'm a bit daunted. What do you think about this layout: [integer booking # (=unique ID)] - [integer start date] - [integer end date] - [text everything

Re: [sqlite] newbie question about laying out a simple database for bookings

2008-04-07 Thread P Kishor
On 4/7/08, sqlfan [EMAIL PROTECTED] wrote: I guess I fit in the more ambitious category then. I hope my workload will increase at any rate. Anyway I've looked at some tutorials, but I'm a bit daunted. What do you think about this layout: [integer booking # (=unique ID)] - [integer