well you hit the nail on the head im afraid. that is the exact structure of my table. and yes john smith can come up where ever the user wishes, as the first, second, third etc team member on any given job.
the days worked are a seperate table, actually a few different tables, based on the products they are working on. for example if they input data for product1, on job1 and product1 on job2, then those values need to be added.
how should i structure my tables to make this possible. if i use ur idea, will the user still be able to select more than one teammember per job?