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 [EMAIL PROTECTED] wrote in message
news:[EMAIL
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 [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What kind of data do you need to collect at each booking?
Shaun
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
What kind of data do you need to collect at each booking?
Shaun [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
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