How should I design a page
I need an Idea on how to make a user friendly data entry. I have a table as above. Its a table for job assigned to contractor(AssignedTo).
Every start of year, there will be list of jobs that will be divided to contractor. 50 jobs will be grouped and be called a package(Pkg).
Each contractor can be assigned 1 or more packages.
Each package assigned to a contractor will have the same Project Description (ProjDesc) and Package number (Pkg).
Each job will be identified by Project Reference (ProjRef).
Once the contractor
complete the job, completion reference (CompletionRef) will be assigned.
My question is, how should I design a data entry page to avoid user to key in the same data (ProjDesc),(Pkg) and only key in (ProjRef). I'm also open to new ideas like redesigning the Database, etc.
Right now what the user do is they key in data into spreadsheet
before exporting it into the database.
My idea is to do like this:-
I just want to know if you have any better idea or how you do it if you have this kind of experience before.