Ok, so I think I might have figured out part of the issue is.
I am passing the Related Client from the Work Order through the Job to the Assignment.
However, the Assignment form/report is a grid edit within the Jobs form.
So when I am adding a new job, that particular job hasn't been generated yet, meaning the record hasn't been generated yet and thus cannot pass down the Related Client to the Assignment.
To complicate things, the Assignment, like mentioned above, is a grid edit report embedded within the jobs.
I would have to save the job first, thus generating the record, and then it would be able to pass down the Related client to the Assignment.
But that defeats the purpose of having the Grid edit in the jobs, to be able to input all the job and multiple related assignments, in one go, without having to save and go back.
Any thoughts or ideas on how I could implement what I am shooting for, but not have to re-do my form structure?
------------------------------
Andrew Fry
------------------------------
