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