Thanks for your reply but the data fields to be captured have to be the same for each project, ie when an administrator sets up project A, he might want to capture fields X, Y, Z for each booking taken for that project... "Gustavo Del Castillo Meza" <gdelcastillo@littledev.com> wrote in message 20030401231858.70890.qmail@pb1.pair.com">news:20030401231858.70890.qmail@pb1.pair.com... > The easiest way to deal with this is to add a TEXT field to the end of the > Booking table and > have the user put in there all the extra data they need. > If this doesnt resolve your problem you could add an etra table called > extraData or something like that it may look like this: > > extraData: > > PK extraData_ID > FK Booking_ID > Description <---- Here you describe the data to be captured Ej. > "Location" > Data <-----And here the actual data Ej. "Quebec" > > This way you can capture "N" records of extra data for the booking > > "Shaun" <shaun@mania.plus.com> escribió en el mensaje > 20030401120759.88268.qmail@pb1.pair.com">news:20030401120759.88268.qmail@pb1.pair.com... > > the data colleccted at each booking will be the fields set by an > > administrator that he/she feels are appropriate to collect for that > project. > > > > > > "Gustavo Del Castillo Meza" <gdelcastillo@littledev.com> wrote in message > > 20030331220048.90651.qmail@pb1.pair.com">news:20030331220048.90651.qmail@pb1.pair.com... > > > What kind of data do you need to collect at each booking? > > > > > > "Shaun" <shaun@mania.plus.com> escribió en el mensaje > > > 20030331203035.5070.qmail@pb1.pair.com">news:20030331203035.5070.qmail@pb1.pair.com... > > > > Hi, > > > > > > > > I am creating a database for a web application. The idea for the > > > application > > > > is for a company administrator to be able to log into the site and > > > allocate > > > > staff to a project. > > > > > > > > Staff will be able to log in and update the status of the project they > > are > > > > working on and clients will be able to log in and book a member of > staff > > > > to their own projects. > > > > > > > > Administrators will be able to add / edit / delete - staff / clients / > > > > projects. > > > > > > > > Here is my database diagram: > > > > > > > > http://www.mania.plus.com > > > > > > > > My problem is each different project will need to have different data > > > > collected for it at each booking. How could I handle this in the > > database > > > > model? The administrator would like to be able to edit the data > > collected > > > > for each project via the site... > > > > > > > > Any other comments on my database model would be appreciated as this > is > > my > > > > weakest area of web development by far! > > > > > > > > > > > > > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
