Customization Help

Charlie,

There are certainly lots of ways to accomplish what you are looking for here. As some have suggested, pulling this in as a view or adding some code to just look it up might save you a UD field but there is no reason what you are trying to do won't work as well. If you just want to slap the data into some bound UD fields I would suggest doing a simple BPM that populates the data into them for you. A pre-processing on JobEntry.Update with an ABL action like this should do the trick:

for each ttJobAsmbl where ttJobAsmbl.ShortChar01 = '':
for first Part fields(ShortChar01) where Part.Company = cur-comp and Part.PartNum = ttJobAsmbl.PartNum no-lock:
ttJobAsmbl.ShortChar01 = Part.ShortChar01.
end.
end.

for each ttJobMtl where ttJobMtl.ShortChar01 = '':
for first Part fields(ShortChar01) where Part.Company = cur-comp and Part.PartNum = ttJobMtl.PartNum no-lock:
ttJobMtl.ShortChar01 = Part.ShortChar01.
end.
end.

Good luck!
Adam

--- In vantage@yahoogroups.com, "sarauscher" <scrausch2@...> wrote:
>
> I have ShortChar field on the Part Table that I want to drive into job entry on both Material and Assembly screens. I am very green at this and looked at the existing part number filed as a guide to set this up. It appears that the part number is using an EpiBinding field of JobMtl.PartNum and a EpiControl of Part.PartNum. So I set up the new field on the Material Tab under Job entry and set the EpicBinding Field of JobMtl.ShorChar01 and the EpiControl of Part.ShorChar01. However the data on the part maintenance screen under ShorChar01 is not pulling through and populating the Job Entry Material Tab. Any suggestions or tips on what I am doing wrong?
>
> Thanks.
>
All,



I have a customization where the user enters an employee ID number in a
field. This ID number then gets stored in a custom DB field. I also have the
form showing the name associated with that id number through a FKV. I now
need to figure out how to make the customization pull the name over to the
same table that is holding the employee number so that I have both the
number and name in the same table.



My goal is to get both the name and number in a list view. Currently it will
only show the number because that is all the table is holding.



Any ideas on how I could do this?



~Charlie





[Non-text portions of this message have been removed]
Are you sure you want to do that? Maybe I'm old school, but I was taught to avoid that sort of thing. Whenever you need the employee name, you have the ID and you can look it up. What happens if the employee's name changes? Do you want the table to show the employee's old name?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Tuesday, January 12, 2010 5:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Customization Help



All,

I have a customization where the user enters an employee ID number in a
field. This ID number then gets stored in a custom DB field. I also have the
form showing the name associated with that id number through a FKV. I now
need to figure out how to make the customization pull the name over to the
same table that is holding the employee number so that I have both the
number and name in the same table.

My goal is to get both the name and number in a list view. Currently it will
only show the number because that is all the table is holding.

Any ideas on how I could do this?

~Charlie

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
I totally agree is there some way to pull a field from a different table
into a list view?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Thomas Rose
Sent: Tuesday, January 12, 2010 9:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization Help





Are you sure you want to do that? Maybe I'm old school, but I was taught to
avoid that sort of thing. Whenever you need the employee name, you have the
ID and you can look it up. What happens if the employee's name changes? Do
you want the table to show the employee's old name?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric <http://www.electricmirror.com>
mirror.com>

Note: The information contained in the e-mail, including any attachments, is
legally privileged and confidential. If you are not the intended recipient
you are hereby notified that any reading, use or dissemination of this
message is strictly prohibited. If you have received this message in error,
please immediately notify us by telephone at 425-776-4946 and delete this
message from your system. Even though this e-mail and any attachments are
believed to be free of any virus or other defect that might affect any
computer system into which it is received and opened, it is the
responsibility of the recipient to ensure that it is virus free, and no
responsibility is accepted by Electric Mirror LLC for any loss or damage
arising in any way from its use

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Charlie Wilson
Sent: Tuesday, January 12, 2010 5:04 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Customization Help

All,

I have a customization where the user enters an employee ID number in a
field. This ID number then gets stored in a custom DB field. I also have the
form showing the name associated with that id number through a FKV. I now
need to figure out how to make the customization pull the name over to the
same table that is holding the employee number so that I have both the
number and name in the same table.

My goal is to get both the name and number in a list view. Currently it will
only show the number because that is all the table is holding.

Any ideas on how I could do this?

~Charlie

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
I don't know. My response was from the good database design school (which it sounds like we agree on), not the Epicor database design school. Someone else will be better equipped than I to answer your question. Sorry I could not be more help.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Tuesday, January 12, 2010 7:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customization Help



I totally agree is there some way to pull a field from a different table
into a list view?

~Charlie

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Thomas Rose
Sent: Tuesday, January 12, 2010 9:25 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Customization Help

Are you sure you want to do that? Maybe I'm old school, but I was taught to
avoid that sort of thing. Whenever you need the employee name, you have the
ID and you can look it up. What happens if the employee's name changes? Do
you want the table to show the employee's old name?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electric <http://www.electricmirror.com>
mirror.com>

Note: The information contained in the e-mail, including any attachments, is
legally privileged and confidential. If you are not the intended recipient
you are hereby notified that any reading, use or dissemination of this
message is strictly prohibited. If you have received this message in error,
please immediately notify us by telephone at 425-776-4946 and delete this
message from your system. Even though this e-mail and any attachments are
believed to be free of any virus or other defect that might affect any
computer system into which it is received and opened, it is the
responsibility of the recipient to ensure that it is virus free, and no
responsibility is accepted by Electric Mirror LLC for any loss or damage
arising in any way from its use

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Charlie Wilson
Sent: Tuesday, January 12, 2010 5:04 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Customization Help

All,

I have a customization where the user enters an employee ID number in a
field. This ID number then gets stored in a custom DB field. I also have the
form showing the name associated with that id number through a FKV. I now
need to figure out how to make the customization pull the name over to the
same table that is holding the employee number so that I have both the
number and name in the same table.

My goal is to get both the name and number in a list view. Currently it will
only show the number because that is all the table is holding.

Any ideas on how I could do this?

~Charlie

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
Have you tried using a retriever adaptor for the field?

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> I totally agree is there some way to pull a field from a different table
> into a list view?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Thomas Rose
> Sent: Tuesday, January 12, 2010 9:25 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Customization Help
>
>
>
>
>
> Are you sure you want to do that? Maybe I'm old school, but I was taught to
> avoid that sort of thing. Whenever you need the employee name, you have the
> ID and you can look it up. What happens if the employee's name changes? Do
> you want the table to show the employee's old name?
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electric <http://www.electricmirror.com>
> mirror.com>
>
> Note: The information contained in the e-mail, including any attachments, is
> legally privileged and confidential. If you are not the intended recipient
> you are hereby notified that any reading, use or dissemination of this
> message is strictly prohibited. If you have received this message in error,
> please immediately notify us by telephone at 425-776-4946 and delete this
> message from your system. Even though this e-mail and any attachments are
> believed to be free of any virus or other defect that might affect any
> computer system into which it is received and opened, it is the
> responsibility of the recipient to ensure that it is virus free, and no
> responsibility is accepted by Electric Mirror LLC for any loss or damage
> arising in any way from its use
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of Charlie Wilson
> Sent: Tuesday, January 12, 2010 5:04 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Customization Help
>
> All,
>
> I have a customization where the user enters an employee ID number in a
> field. This ID number then gets stored in a custom DB field. I also have the
> form showing the name associated with that id number through a FKV. I now
> need to figure out how to make the customization pull the name over to the
> same table that is holding the employee number so that I have both the
> number and name in the same table.
>
> My goal is to get both the name and number in a list view. Currently it will
> only show the number because that is all the table is holding.
>
> Any ideas on how I could do this?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I'm not familiar with that could you enlighten me?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cmulford_66
Sent: Tuesday, January 12, 2010 4:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customization Help





Have you tried using a retriever adaptor for the field?

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...> wrote:
>
> I totally agree is there some way to pull a field from a different table
> into a list view?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> Thomas Rose
> Sent: Tuesday, January 12, 2010 9:25 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Customization Help
>
>
>
>
>
> Are you sure you want to do that? Maybe I'm old school, but I was taught
to
> avoid that sort of thing. Whenever you need the employee name, you have
the
> ID and you can look it up. What happens if the employee's name changes? Do
> you want the table to show the employee's old name?
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electric <http://www.electric
<http://www.electricmirror.com> mirror.com>
> mirror.com>
>
> Note: The information contained in the e-mail, including any attachments,
is
> legally privileged and confidential. If you are not the intended recipient
> you are hereby notified that any reading, use or dissemination of this
> message is strictly prohibited. If you have received this message in
error,
> please immediately notify us by telephone at 425-776-4946 and delete this
> message from your system. Even though this e-mail and any attachments are
> believed to be free of any virus or other defect that might affect any
> computer system into which it is received and opened, it is the
> responsibility of the recipient to ensure that it is virus free, and no
> responsibility is accepted by Electric Mirror LLC for any loss or damage
> arising in any way from its use
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of Charlie Wilson
> Sent: Tuesday, January 12, 2010 5:04 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Customization Help
>
> All,
>
> I have a customization where the user enters an employee ID number in a
> field. This ID number then gets stored in a custom DB field. I also have
the
> form showing the name associated with that id number through a FKV. I now
> need to figure out how to make the customization pull the name over to the
> same table that is holding the employee number so that I have both the
> number and name in the same table.
>
> My goal is to get both the name and number in a list view. Currently it
will
> only show the number because that is all the table is holding.
>
> Any ideas on how I could do this?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
In 8.03.400 it's in the customization tools. When you add a field using the toolbox and select the datafield there is a Retriever check box. Select it you'll see a list the available adaptors. You then select what adaptor combo type for the listview you want to use. The adaptors allow you to link other (even unrelated) tables to the added field and populate them with the info from that table. I have seen an EMPBasic Adaptor out there, I would assume this is what you need.

I used a CustomerAdaptor with a CustomerCombo on the Part Setup menu. It allows the user to select which customer a part belongs to. The user gets a pulldown list of all the customers to select from and the Part.character10 field gets populated with the CustID when they select it.


--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> I'm not familiar with that could you enlighten me?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> cmulford_66
> Sent: Tuesday, January 12, 2010 4:29 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Customization Help
>
>
>
>
>
> Have you tried using a retriever adaptor for the field?
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
> Wilson" <foamdesigncsw@> wrote:
> >
> > I totally agree is there some way to pull a field from a different table
> > into a list view?
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > Thomas Rose
> > Sent: Tuesday, January 12, 2010 9:25 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: RE: [Vantage] Customization Help
> >
> >
> >
> >
> >
> > Are you sure you want to do that? Maybe I'm old school, but I was taught
> to
> > avoid that sort of thing. Whenever you need the employee name, you have
> the
> > ID and you can look it up. What happens if the employee's name changes? Do
> > you want the table to show the employee's old name?
> >
> > Thom Rose
> > Controller
> > Electric Mirror LLC
> > HOTEL LUXURY
> >
> > "The World Leader in Back-lit Mirrors & Mirror TV Technology"
> >
> > T 425 776-4946
> > A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> > www.electricmirror.com<http://www.electric <http://www.electric
> <http://www.electricmirror.com> mirror.com>
> > mirror.com>
> >
> > Note: The information contained in the e-mail, including any attachments,
> is
> > legally privileged and confidential. If you are not the intended recipient
> > you are hereby notified that any reading, use or dissemination of this
> > message is strictly prohibited. If you have received this message in
> error,
> > please immediately notify us by telephone at 425-776-4946 and delete this
> > message from your system. Even though this e-mail and any attachments are
> > believed to be free of any virus or other defect that might affect any
> > computer system into which it is received and opened, it is the
> > responsibility of the recipient to ensure that it is virus free, and no
> > responsibility is accepted by Electric Mirror LLC for any loss or damage
> > arising in any way from its use
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> > Behalf Of Charlie Wilson
> > Sent: Tuesday, January 12, 2010 5:04 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Customization Help
> >
> > All,
> >
> > I have a customization where the user enters an employee ID number in a
> > field. This ID number then gets stored in a custom DB field. I also have
> the
> > form showing the name associated with that id number through a FKV. I now
> > need to figure out how to make the customization pull the name over to the
> > same table that is holding the employee number so that I have both the
> > number and name in the same table.
> >
> > My goal is to get both the name and number in a list view. Currently it
> will
> > only show the number because that is all the table is holding.
> >
> > Any ideas on how I could do this?
> >
> > ~Charlie
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Thanks!



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cmulford_66
Sent: Wednesday, January 13, 2010 2:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customization Help





In 8.03.400 it's in the customization tools. When you add a field using the
toolbox and select the datafield there is a Retriever check box. Select it
you'll see a list the available adaptors. You then select what adaptor combo
type for the listview you want to use. The adaptors allow you to link other
(even unrelated) tables to the added field and populate them with the info
from that table. I have seen an EMPBasic Adaptor out there, I would assume
this is what you need.

I used a CustomerAdaptor with a CustomerCombo on the Part Setup menu. It
allows the user to select which customer a part belongs to. The user gets a
pulldown list of all the customers to select from and the Part.character10
field gets populated with the CustID when they select it.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...> wrote:
>
> I'm not familiar with that could you enlighten me?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> cmulford_66
> Sent: Tuesday, January 12, 2010 4:29 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: Customization Help
>
>
>
>
>
> Have you tried using a retriever adaptor for the field?
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"Charlie
> Wilson" <foamdesigncsw@> wrote:
> >
> > I totally agree is there some way to pull a field from a different table
> > into a list view?
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > Thomas Rose
> > Sent: Tuesday, January 12, 2010 9:25 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: RE: [Vantage] Customization Help
> >
> >
> >
> >
> >
> > Are you sure you want to do that? Maybe I'm old school, but I was taught
> to
> > avoid that sort of thing. Whenever you need the employee name, you have
> the
> > ID and you can look it up. What happens if the employee's name changes?
Do
> > you want the table to show the employee's old name?
> >
> > Thom Rose
> > Controller
> > Electric Mirror LLC
> > HOTEL LUXURY
> >
> > "The World Leader in Back-lit Mirrors & Mirror TV Technology"
> >
> > T 425 776-4946
> > A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> > www.electricmirror.com<http://www.electric <http://www.electric
> <http://www.electric <http://www.electricmirror.com> mirror.com>
mirror.com>
> > mirror.com>
> >
> > Note: The information contained in the e-mail, including any
attachments,
> is
> > legally privileged and confidential. If you are not the intended
recipient
> > you are hereby notified that any reading, use or dissemination of this
> > message is strictly prohibited. If you have received this message in
> error,
> > please immediately notify us by telephone at 425-776-4946 and delete
this
> > message from your system. Even though this e-mail and any attachments
are
> > believed to be free of any virus or other defect that might affect any
> > computer system into which it is received and opened, it is the
> > responsibility of the recipient to ensure that it is virus free, and no
> > responsibility is accepted by Electric Mirror LLC for any loss or damage
> > arising in any way from its use
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> > Behalf Of Charlie Wilson
> > Sent: Tuesday, January 12, 2010 5:04 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Customization Help
> >
> > All,
> >
> > I have a customization where the user enters an employee ID number in a
> > field. This ID number then gets stored in a custom DB field. I also have
> the
> > form showing the name associated with that id number through a FKV. I
now
> > need to figure out how to make the customization pull the name over to
the
> > same table that is holding the employee number so that I have both the
> > number and name in the same table.
> >
> > My goal is to get both the name and number in a list view. Currently it
> will
> > only show the number because that is all the table is holding.
> >
> > Any ideas on how I could do this?
> >
> > ~Charlie
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I have ShortChar field on the Part Table that I want to drive into job entry on both Material and Assembly screens. I am very green at this and looked at the existing part number filed as a guide to set this up. It appears that the part number is using an EpiBinding field of JobMtl.PartNum and a EpiControl of Part.PartNum. So I set up the new field on the Material Tab under Job entry and set the EpicBinding Field of JobMtl.ShorChar01 and the EpiControl of Part.ShorChar01. However the data on the part maintenance screen under ShorChar01 is not pulling through and populating the Job Entry Material Tab. Any suggestions or tips on what I am doing wrong?

Thanks.
If you are not looking to edit the field from within job entry but just have it pull through for viewing the easiest way to achieve this is by using a foreign key view. There are lots of instructions on the group here of to get a foreign key view setup. I can't recall if the part dataview is available in job entry already or not.
reply Signature





Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "sarauscher" <scrausch2@...>
To: vantage@yahoogroups.com
Sent: Wednesday, March 20, 2013 9:52:21 PM
Subject: [Vantage] Customization Help



I have ShortChar field on the Part Table that I want to drive into job entry on both Material and Assembly screens. I am very green at this and looked at the existing part number filed as a guide to set this up. It appears that the part number is using an EpiBinding field of JobMtl.PartNum and a EpiControl of Part.PartNum. So I set up the new field on the Material Tab under Job entry and set the EpicBinding Field of JobMtl.ShorChar01 and the EpiControl of Part.ShorChar01. However the data on the part maintenance screen under ShorChar01 is not pulling through and populating the Job Entry Material Tab. Any suggestions or tips on what I am doing wrong?

Thanks.





[Non-text portions of this message have been removed]