Epicor 9.05.702a and Foreign Key Views

Yahoo Archive
1
  Yes we are on SQL 64bit 701


--- In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Not sure if you are on SQL but Epicor 9.05 on SQL does not have keys.



--- In vantage@yahoogroups.com , "s1mhall" <s1mhall@...> wrote:

>

> Yes Trying to do this in 701 and I can't get them to work. Using the add UD as a child wizard does appear to work though.

>

> Cheers

> Simon Hall

>

> --- In vantage@yahoogroups.com , "Charles Carden" <shadowcar1449@> wrote:

> >

> > I had foreign key views in Vantage 8.03.410 that are no longer valid when we upgraded to Epicor 9. I tried to recreate the FKV but so far I have not had any luck. The main problem seems to be in the Custom Column Like as it will not retain the Like Column Value. I have done everything I know how to do and yet I cannot get it to retain the Like Column Value. I can define it and define the FKV but when I leave the customization and exit the program The Like Column Value is missing and consequently the FKV is no longer valid.

> >

> > Has anyone else run across this problem and if so how did you fix it?

> >

> > Thanks in advance.

> >

> >

> > Charles Carden

> > IT Manager

> > Manitex, Inc.

> > Georgetown, Texas

> >

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

> >

>
2
I had foreign key views in Vantage 8.03.410 that are no longer valid when we upgraded to Epicor 9. I tried to recreate the FKV but so far I have not had any luck. The main problem seems to be in the Custom Column Like as it will not retain the Like Column Value. I have done everything I know how to do and yet I cannot get it to retain the Like Column Value. I can define it and define the FKV but when I leave the customization and exit the program The Like Column Value is missing and consequently the FKV is no longer valid.

Has anyone else run across this problem and if so how did you fix it?

Thanks in advance.


Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas

[Non-text portions of this message have been removed]
3
Yes Trying to do this in 701 and I can't get them to work. Using the add UD as a child wizard does appear to work though.

Cheers
Simon Hall

--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> I had foreign key views in Vantage 8.03.410 that are no longer valid when we upgraded to Epicor 9. I tried to recreate the FKV but so far I have not had any luck. The main problem seems to be in the Custom Column Like as it will not retain the Like Column Value. I have done everything I know how to do and yet I cannot get it to retain the Like Column Value. I can define it and define the FKV but when I leave the customization and exit the program The Like Column Value is missing and consequently the FKV is no longer valid.
>
> Has anyone else run across this problem and if so how did you fix it?
>
> Thanks in advance.
>
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
>
> [Non-text portions of this message have been removed]
>
4
Not sure if you are on SQL but Epicor 9.05 on SQL does not have keys.

--- In vantage@yahoogroups.com, "s1mhall" <s1mhall@...> wrote:
>
> Yes Trying to do this in 701 and I can't get them to work. Using the add UD as a child wizard does appear to work though.
>
> Cheers
> Simon Hall
>
> --- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@> wrote:
> >
> > I had foreign key views in Vantage 8.03.410 that are no longer valid when we upgraded to Epicor 9. I tried to recreate the FKV but so far I have not had any luck. The main problem seems to be in the Custom Column Like as it will not retain the Like Column Value. I have done everything I know how to do and yet I cannot get it to retain the Like Column Value. I can define it and define the FKV but when I leave the customization and exit the program The Like Column Value is missing and consequently the FKV is no longer valid.
> >
> > Has anyone else run across this problem and if so how did you fix it?
> >
> > Thanks in advance.
> >
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> > Georgetown, Texas
> >
> > [Non-text portions of this message have been removed]
> >
>
5
You have to set the link in the Extended Properties in 700 because the old
method is broken.



Steve



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
s1mhall
Sent: Wednesday, August 28, 2013 2:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9.05.702a and Foreign Key Views





Yes Trying to do this in 701 and I can't get them to work. Using the add UD
as a child wizard does appear to work though.

Cheers
Simon Hall

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Charles
Carden" <shadowcar1449@...> wrote:
>
> I had foreign key views in Vantage 8.03.410 that are no longer valid when
we upgraded to Epicor 9. I tried to recreate the FKV but so far I have not
had any luck. The main problem seems to be in the Custom Column Like as it
will not retain the Like Column Value. I have done everything I know how to
do and yet I cannot get it to retain the Like Column Value. I can define it
and define the FKV but when I leave the customization and exit the program
The Like Column Value is missing and consequently the FKV is no longer
valid.
>
> Has anyone else run across this problem and if so how did you fix it?
>
> Thanks in advance.
>
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
6
Steve,
I tried using extended properties, but just couldn't get it to work.

Here is what I am trying to do. Just a recap.

On customer form I want to link a person contact record on a new tab.
On the new tab I want to include one field that held the perconid (thinking of using number01). Other fields on the tab would just be read only display of the content from the percon table.

At this point I get confused.. Do you set the like up on the percon.perconid field or on the Customer.Number01 field. Once I get the link working correctly I assume I can then add extra fields on the tab that will display information from the PerCon table?

Cheers
Simon

--- In vantage@yahoogroups.com, "Steve" <vantage@...> wrote:
>
> You have to set the link in the Extended Properties in 700 because the old
> method is broken.
>
>
>
> Steve
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> s1mhall
> Sent: Wednesday, August 28, 2013 2:58 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Epicor 9.05.702a and Foreign Key Views
>
>
>
>
>
> Yes Trying to do this in 701 and I can't get them to work. Using the add UD
> as a child wizard does appear to work though.
>
> Cheers
> Simon Hall
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Charles
> Carden" <shadowcar1449@> wrote:
> >
> > I had foreign key views in Vantage 8.03.410 that are no longer valid when
> we upgraded to Epicor 9. I tried to recreate the FKV but so far I have not
> had any luck. The main problem seems to be in the Custom Column Like as it
> will not retain the Like Column Value. I have done everything I know how to
> do and yet I cannot get it to retain the Like Column Value. I can define it
> and define the FKV but when I leave the customization and exit the program
> The Like Column Value is missing and consequently the FKV is no longer
> valid.
> >
> > Has anyone else run across this problem and if so how did you fix it?
> >
> > Thanks in advance.
> >
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> > Georgetown, Texas
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
First create the link between in the extended properties between the
Contact.PerConID to percon.perconid.

Then edit your customized screen and the foreign key view from the
Contact.PerConList to the percon.perconid.



The Number01 field should now be available for selection when adding a field
from the toolbox. The only thing is I have never linked between a list so I
do not know if it will pull in all the percon data.



Steve



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
s1mhall
Sent: Friday, August 30, 2013 6:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9.05.702a and Foreign Key Views





Steve,
I tried using extended properties, but just couldn't get it to work.

Here is what I am trying to do. Just a recap.

On customer form I want to link a person contact record on a new tab.
On the new tab I want to include one field that held the perconid (thinking
of using number01). Other fields on the tab would just be read only display
of the content from the percon table.

At this point I get confused.. Do you set the like up on the percon.perconid
field or on the Customer.Number01 field. Once I get the link working
correctly I assume I can then add extra fields on the tab that will display
information from the PerCon table?

Cheers
Simon

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Steve"
<vantage@...> wrote:
>
> You have to set the link in the Extended Properties in 700 because the old
> method is broken.
>
>
>
> Steve
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> s1mhall
> Sent: Wednesday, August 28, 2013 2:58 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Epicor 9.05.702a and Foreign Key Views
>
>
>
>
>
> Yes Trying to do this in 701 and I can't get them to work. Using the add
UD
> as a child wizard does appear to work though.
>
> Cheers
> Simon Hall
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Charles
> Carden" <shadowcar1449@> wrote:
> >
> > I had foreign key views in Vantage 8.03.410 that are no longer valid
when
> we upgraded to Epicor 9. I tried to recreate the FKV but so far I have not
> had any luck. The main problem seems to be in the Custom Column Like as it
> will not retain the Like Column Value. I have done everything I know how
to
> do and yet I cannot get it to retain the Like Column Value. I can define
it
> and define the FKV but when I leave the customization and exit the program
> The Like Column Value is missing and consequently the FKV is no longer
> valid.
> >
> > Has anyone else run across this problem and if so how did you fix it?
> >
> > Thanks in advance.
> >
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> > Georgetown, Texas
> >
> > [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]