jacomus Posted April 23, 2008 Share Posted April 23, 2008 I am just wondering for a booking system that will require hundreds of items which will be booked for multiple dates... Will I have to create a table for each of the items or is there a method by which I can create a single table with all of the items in one column and all of the booking dates in the rows beside each item? Quote Link to comment Share on other sites More sharing options...
fenway Posted April 23, 2008 Share Posted April 23, 2008 Well, not "beside".... simply have each row contain an item_uid which points to items in another table. Then have a bookings table with the start/end dates. Quote Link to comment Share on other sites More sharing options...
jacomus Posted April 23, 2008 Author Share Posted April 23, 2008 Thanks, I wasn't even considering something along those lines. Much appreciated =) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.