that does make more sense. i'll give it a try and see what i come up with. Thanks.
--- In vantage@yahoogroups.com, "rossh777" <ross.hughes3@...> wrote:
>
>
>
> If you are trying to link shortchar01 to JCDept across tables you will have to use a BPM or customization.
>
> --- In vantage@yahoogroups.com, "rossh777" <ross.hughes3@> wrote:
> >
> >
> >
> > The JCDept data is only coming from a retriever combo. You are linking the JCDept ID to the shortchar01.
> >
> > The idea is that you are using *.shortchar01 in the ECOMtl, PartMtl and JobMtl tables. When you check in and out, and move data around between these tables, the shortchar01 field maintains the same data. If you want to see the data in all of the tables you will need to add a retriever combo for JCDept to the method tracker, EWB, QuoteEntry and Job Entry, etc. They would all bind to shortchar01 in this example. Create an entry for whatever tables you want to transport the data, and typically in both directions.
> >
> > In custom field maintenance, map ECOMtl.ShortChar01 to PartMtl.ShortChar01. Then, do it the other way around. That should cover checking out and in parts. If you want to have it transport to jobs you will have to add entries for PartMtl.Shortchar01 to JobMtl.ShortChar01. Again, do this the other way around as well if you want to import job materials in to methods.
> >
> > Does this make more sense?
> >
> > Ross
> >
> > --- In vantage@yahoogroups.com, "ralmon64" <ralmon@> wrote:
> > >
> > > Thanks for the quick response but i don't think that solves my problem. I'm trying to pull in the JCDept table and that table is not an option in field map maintenance. The second part of this which would be taking it from the ECOMtl table to the JobMtl table doesn't seem to be handled by Field Mapping either. I can make my target table ECOMtl and my source table JobMtl. But wouldn't this pull the data in the wrong direction? Also I still can't get it to save the data in ECOMtl table.
> > >
> > > Thanks.
> > >
> > > --- In vantage@yahoogroups.com, "rossh777" <ross.hughes3@> wrote:
> > > >
> > > >
> > > >
> > > > You need to create an entry in the Custom Field Map in the System Management | Utilities folder for both directions. This will link your fields back and forth from the ECO tables to the Part tables, etc.
> > > >
> > > > Ross
> > > >
> > >
> >
>