Order Field to Job Entry

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
I was able to pull in the order tl I have about 30 fields I pull in
by using an ultragrid. The user just clicks the order in the
ultragrid to pull in all the info. And actually they only see the
order that correlates to that job so they click the only line there.
If you are interested I could explain better.
> I added a field on Order Line, OrderDtl.ShortChar01, which get
filled
> in with information that I want to pick up in Job Entry,
> JobHead,ShortChar01, when the Production person first opens up the
> Job in Job Entry.
>
> In our enviroment the Sales user creates the Job Header through
Order
> Job Wizard and Print a Job Summary sheet which get put into a Job
> Travler and moved to Production. This is what triggers Production
to
> Open up the Job and Engineer it.
>
> The field from Order Line, OrderDtrl.ShortChar01, gets re-typed in
at
> Job Entry in field JobHead.ShortChar01, from the data that is
printed
> on a Job Summary sheet from Sales.
>
> I want to have the JobHead.ShortChar01 field pull in the
information
> from Order Line without them having to re-type it.
>
> We went Live back in August and I have background in VB.Net but
just
> can't seem to get head wrapped around this to make it happen.
>
> I did explore the Foriegn Key route and there is no Like Column
Value
> commonality between OrderDtl and JobHead.
>
> So I want to do a Before Field Change event key off the Job Number
> field, have it use the Sales Order Adapter(?) and pull the
> information into Job Entry if there is something in
> OrderDtl.ShortChar01 and if there is nothing in JobHead.ShortChar01.
>
> Any help would be appreciate.
>
> Vantage 8.00.809
>
> Scott Litzau
> IS Manager
> Olymus Flag & Banner
>
I added a field on Order Line, OrderDtl.ShortChar01, which get filled
in with information that I want to pick up in Job Entry,
JobHead,ShortChar01, when the Production person first opens up the
Job in Job Entry.

In our enviroment the Sales user creates the Job Header through Order
Job Wizard and Print a Job Summary sheet which get put into a Job
Travler and moved to Production. This is what triggers Production to
Open up the Job and Engineer it.

The field from Order Line, OrderDtrl.ShortChar01, gets re-typed in at
Job Entry in field JobHead.ShortChar01, from the data that is printed
on a Job Summary sheet from Sales.

I want to have the JobHead.ShortChar01 field pull in the information
from Order Line without them having to re-type it.

We went Live back in August and I have background in VB.Net but just
can't seem to get head wrapped around this to make it happen.

I did explore the Foriegn Key route and there is no Like Column Value
commonality between OrderDtl and JobHead.

So I want to do a Before Field Change event key off the Job Number
field, have it use the Sales Order Adapter(?) and pull the
information into Job Entry if there is something in
OrderDtl.ShortChar01 and if there is nothing in JobHead.ShortChar01.

Any help would be appreciate.

Vantage 8.00.809

Scott Litzau
IS Manager
Olymus Flag & Banner