I have come to a cross roads with my app and not sure how to proceed with the form I want to create. The form needs to display Client and Job information & numerous job detail records, then allow the user to enter new jod details plus add time and item records at the same time. Attached is the database layout.
‘CLIENT’ table : holds client information such as organisation name, contact details, address etc
‘JOB’ table : holds details on summary & task information + organised date/time for job, assigned to who etc
‘JOBDET’ table : everytime we do something to a job it gets recorded in a jobdet record.
‘TIME’ table : we store time charged here if the jobdet was chargable.
‘ITEM’ table : same as time table but for hardware used
I want a page that can show and do the following;
CLIENT <— static text, basic client info here
JOB <— static text, basic job details here, jobdesc (basically tasks needing done)
JOBDET <— the next five jobdet records are text only (what we did on that visitation)
JOBDET
TIME <— this jobdet has a time record, we charged the client
JOBDET
TIME <— this jobdet has a time record, we charged the client + a part
ITEM
JOBDET <— another jobdet entry with 2 x time entries attached
TIME
TIME
JOBDET
form:JOBDET <— blank form to add another jobdet entry
form:TIME <— blank form to add a time record (NOT mandatory)
form:ITEM <— blank form to add a item record (NOT mandatory)
With respect to the TIME and ITEM forms, we need to be able to submit none or multiples ie a checkbox in front of the form to allow submission and a (+) to add a new form to be added underneath. So submission will be 1 jobdet record & 0+ time and 0+ item records.
Example;
ThisCompanyCo Pty/Ltd
156 Annadale St Lismore NSW 2333
Fred Smith - Ph(02) 6666 2222
Assignedto: Robert
OrgDate: 25/6/2010 09:00 - 11:00
Summary: Fix Printer, misc tasks
TaskDesc:
1/ Printer not working
2/ 1 x workstation not on Internet
3/ Tasks as directed by client
jobdet: Called client, discussed issues, organised onsite time
jobdet: 25/6/2010; Onsite, resolved printer issues, need 2nd visit
time: 1hr/$88
jobdet: 26/6/2010; 2nd visit, fixed Internet issues, dead network switch.
time: 2hrs/$88
item: 1 x network switch, $35
jobdet: Discussed remaining issues on phone, pended till they have freetime.
form-jobdet: _____________ ______ etc
[ ] time ____________ (+)
[ ] item ____________ (+)
**** the [ ] is a checkbox logic to allow submission, the (+) is code to create another form of either time or item.
Hopefully this give the general idea… Any thoughts on how to do this?! And thanks!