Pulling data from a tbl

**steveallany2k6** · 12-19-2012, 05:23 AM

hi all,
iu have a table with a list of people in one column, and the other columns are jobs which need to be done. what code would i use to gothrough the list and then create task for each person depending wether the task is ticked for them

[Name] [Job1] [Job2] [Job3] ................................................
P1 X X
P2 X X
.
.
.

in the task table P1 would have a task called Job1 and one called Job3
and P2 would have one called Job2 and one Job3
basically scrolling through the table and using the header as the string if the checkbox equals true.
if someone could help with this that would be great

Thanks in advance

**alansidman** · 12-19-2012, 08:12 AM

You have a normalization issue that will make this difficult.

Please read this on building a relational database.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

You have your table set up as if it were a spreadsheet.

It should probably resemble this. I envision at least two tables and possibly three

tablename
NameID PK
FName
LName
Other fields as needed

JobTable
JobID PK
JobDescription

TaskTable
TaskID PK
NameID FK
JobID FK

Once you have a normalized db, you can run queries to determine assignments,etc.

**steveallany2k6** · 12-19-2012, 08:14 AM

i do have it set up like that, so what would i do to create a new job for a person with a query?

**alansidman** · 12-19-2012, 08:50 PM

It would help if you posted some sample data of what is in your tables and what the expected results should look like. I don't quite get it from the example shown. Please show real life type (although ficticious) data. Pictures say a lot sometimes.