[eluser]joncarl[/eluser]
Hey All,
I'm writing an application to print invoicing for people receiving services in mental health and mental retardation in Pennsylvania. Now I'm running into a bit of a head scratcher, I have two tables a Assignment Table (the job we are doing) and a Contacts Table (the work performed) my final result needs to look a bit like this:
A Job LVS MH Fund 24.95 (One row with the job performed)
4/10/2009 10 Attended 24.95
4/11/2009 14 Absent-Medical
4/12/2009 4 Attended 24.95
.... (Multiple rows showing work performed for the job)
A Second Job LVS MH Fund 24.95 (Next Job)
4/10/2009 1 Attended 24.95
.... (Rinse and repeat until complete)
So I figured the best way to handle this was with a multidimension array, but for the life of me I can't figure out the best way to go about it that is the most efficient.
If anybody could throw a helpful hint my way that would be great!
Thanks!