What do I use?

[vbuser1976]

Hi everyone,

I hope you enjoyed your weekend. Here's my problem:

I created a form page that keeps track of projects. The first part of the page is pretty basic, i.e. name of project, date due, project notes, etc. Now my boss wants me to add a 'Task List'. Basically, the list would consist of a list of people with their assigned task for that specific project. So, therefore, for each project, there can be multiple people doing a separate task. I need to find out what is the best way of doing this. Should I create an array with a data grid or what? Please show code examples as well.

Thanks in advance.

[JoshT]

A good old normalized database should do the trick. Have a table for projects, a table for people, and then a table that links the two together.

Josh

[vbuser1976]

Thanks for your input.

Now, my next question is this: Can I create a datagrid or something similar on the page so that the user can have the ability to add/edit persons on the task list per project? Basically, I am looking for something like a Access data input interface, where columns automatically add themselves when you have a new entry.

I hope that this does not sound confusing.

[JoshT]

I would use a combination of HTML tables and forms populated from the database. Then stick an empty row/form at the bottom of the table for a new entry.

Josh

[vbuser1976]

Ok, thanks for your help.

That is what I needed to start with. BTW, you live in Buffalo? Since your profile says West NY