Using a UD Table in a Foreign Key View

Yahoo Archive
1
Rob/Stephen,



That explains why I was having trouble with the code from the Help
topic. Thank you both for your helpful comments. I'll let you know when
I have success. I've been to the Advanced Customization class and have
the Tools Guide but there's still a lot to learn and this forum is quite
helpful!



Gary York

Aqua-Aerobic Systems



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Wednesday, December 19, 2007 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Using a UD Table in a Foreign Key View



Under 305i & 403c, the code out of the help file doesn't function until
you tweak it a little. (If I remember correctly, their are some syntax
typos.)

You still need to add the UD custom assemblies needed (and that isn't
mentioned in the help file - or Epicor Tools User Guide) at all.



Stephen Edginton <stephene@...
<mailto:stephene%40dotnetit.co.uk> > wrote:
Gary / Robert

Just as a note,

If you search for "UDXX" in the help there is a document
titled "How can a user-defined table become a foreign key view option?"

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Robert Brown
Sent: Wednesday, December 19, 2007 5:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Using a UD Table in a Foreign Key View

Did you add the necessary custom assemblies to your customization (to
make the UD adapter accessible)?

Assuming that is the step missed, you still will likely have difficulty
adding the UD table as and FKV. (It is much easier to code directly and
bring it in as a DataView.) There are no 'natural' primary key fields in
the UD table to associate the OrderDtl table.

To establish and FKV, you often have to create a chain of related FKV's
to finally make the relationship available that is necessary to add the
FKV of the table you are really interested in.

FKV's are a capability which you would expect to make things very simple
(to produce powerful, hybrid customizations) - but it is often much more
trouble than it is worth to explore (via trial and error - as there
seems to be little logic behind it) the myriad of potential chained FKV
paths that might allow you to reach and tie into your table of interest.

Perhaps someday Epicor will document it (much) better to negate the
potential for wasting development time on what proves to be a dead end.

gyorkillinois <gyork@... <mailto:gyork%40aqua-aerobic.com>
<mailto:gyork%40aqua-aerobic.com>
> wrote:
I would like to add some UD fields to a custom sheet in Sales Order
Entry. I am trying to create a foreign key view linking the UD table to
the OrderDtl table. I have added the UD table to a menu as required but
don't see the UD table in the list of data sources in the foreign key
view build area. We have Vantage 8.03.403D. Does anyone have any
suggestions?

Gary York

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

---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
it now.

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





[Non-text portions of this message have been removed]
2
I would like to add some UD fields to a custom sheet in Sales Order
Entry. I am trying to create a foreign key view linking the UD table to
the OrderDtl table. I have added the UD table to a menu as required but
don't see the UD table in the list of data sources in the foreign key
view build area. We have Vantage 8.03.403D. Does anyone have any
suggestions?

Gary York
3
Did you add the necessary custom assemblies to your customization (to make the UD adapter accessible)?

Assuming that is the step missed, you still will likely have difficulty adding the UD table as and FKV. (It is much easier to code directly and bring it in as a DataView.) There are no 'natural' primary key fields in the UD table to associate the OrderDtl table.

To establish and FKV, you often have to create a chain of related FKV's to finally make the relationship available that is necessary to add the FKV of the table you are really interested in.

FKV's are a capability which you would expect to make things very simple (to produce powerful, hybrid customizations) - but it is often much more trouble than it is worth to explore (via trial and error - as there seems to be little logic behind it) the myriad of potential chained FKV paths that might allow you to reach and tie into your table of interest.

Perhaps someday Epicor will document it (much) better to negate the potential for wasting development time on what proves to be a dead end.







gyorkillinois <gyork@...> wrote:
I would like to add some UD fields to a custom sheet in Sales Order
Entry. I am trying to create a foreign key view linking the UD table to
the OrderDtl table. I have added the UD table to a menu as required but
don't see the UD table in the list of data sources in the foreign key
view build area. We have Vantage 8.03.403D. Does anyone have any
suggestions?

Gary York






---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[Non-text portions of this message have been removed]
4
Gary / Robert



Just as a note,

If you search for "UDXX" in the help there is a document
titled "How can a user-defined table become a foreign key view option?"





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Wednesday, December 19, 2007 5:59 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Using a UD Table in a Foreign Key View



Did you add the necessary custom assemblies to your customization (to
make the UD adapter accessible)?

Assuming that is the step missed, you still will likely have difficulty
adding the UD table as and FKV. (It is much easier to code directly and
bring it in as a DataView.) There are no 'natural' primary key fields in
the UD table to associate the OrderDtl table.

To establish and FKV, you often have to create a chain of related FKV's
to finally make the relationship available that is necessary to add the
FKV of the table you are really interested in.

FKV's are a capability which you would expect to make things very simple
(to produce powerful, hybrid customizations) - but it is often much more
trouble than it is worth to explore (via trial and error - as there
seems to be little logic behind it) the myriad of potential chained FKV
paths that might allow you to reach and tie into your table of interest.

Perhaps someday Epicor will document it (much) better to negate the
potential for wasting development time on what proves to be a dead end.



gyorkillinois <gyork@... <mailto:gyork%40aqua-aerobic.com>
> wrote:
I would like to add some UD fields to a custom sheet in Sales Order
Entry. I am trying to create a foreign key view linking the UD table to
the OrderDtl table. I have added the UD table to a menu as required but
don't see the UD table in the list of data sources in the foreign key
view build area. We have Vantage 8.03.403D. Does anyone have any
suggestions?

Gary York









[Non-text portions of this message have been removed]
5
Under 305i & 403c, the code out of the help file doesn't function until you tweak it a little. (If I remember correctly, their are some syntax typos.)

You still need to add the UD custom assemblies needed (and that isn't mentioned in the help file - or Epicor Tools User Guide) at all.



Stephen Edginton <stephene@...> wrote:
Gary / Robert

Just as a note,

If you search for "UDXX" in the help there is a document
titled "How can a user-defined table become a foreign key view option?"

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Wednesday, December 19, 2007 5:59 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Using a UD Table in a Foreign Key View

Did you add the necessary custom assemblies to your customization (to
make the UD adapter accessible)?

Assuming that is the step missed, you still will likely have difficulty
adding the UD table as and FKV. (It is much easier to code directly and
bring it in as a DataView.) There are no 'natural' primary key fields in
the UD table to associate the OrderDtl table.

To establish and FKV, you often have to create a chain of related FKV's
to finally make the relationship available that is necessary to add the
FKV of the table you are really interested in.

FKV's are a capability which you would expect to make things very simple
(to produce powerful, hybrid customizations) - but it is often much more
trouble than it is worth to explore (via trial and error - as there
seems to be little logic behind it) the myriad of potential chained FKV
paths that might allow you to reach and tie into your table of interest.

Perhaps someday Epicor will document it (much) better to negate the
potential for wasting development time on what proves to be a dead end.

gyorkillinois <gyork@... <mailto:gyork%40aqua-aerobic.com>
> wrote:
I would like to add some UD fields to a custom sheet in Sales Order
Entry. I am trying to create a foreign key view linking the UD table to
the OrderDtl table. I have added the UD table to a menu as required but
don't see the UD table in the list of data sources in the foreign key
view build area. We have Vantage 8.03.403D. Does anyone have any
suggestions?

Gary York

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






---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[Non-text portions of this message have been removed]
6
Robert/Stephen,

This explains why I wasn't having success with the solution in the
Help topic. Thanks for pointing me in the right direction. I'll reply
with my results.

Gary York
Aqua-Aerobic Systems

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> Under 305i & 403c, the code out of the help file doesn't function
until you tweak it a little. (If I remember correctly, their are some
syntax typos.)
>
> You still need to add the UD custom assemblies needed (and that
isn't mentioned in the help file - or Epicor Tools User Guide) at all.
>
>
>
> Stephen Edginton <stephene@...> wrote:
> Gary / Robert
>
> Just as a note,
>
> If you search for "UDXX" in the help there is a document
> titled "How can a user-defined table become a foreign key view
option?"
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Robert Brown
> Sent: Wednesday, December 19, 2007 5:59 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Using a UD Table in a Foreign Key View
>
> Did you add the necessary custom assemblies to your customization
(to
> make the UD adapter accessible)?
>
> Assuming that is the step missed, you still will likely have
difficulty
> adding the UD table as and FKV. (It is much easier to code directly
and
> bring it in as a DataView.) There are no 'natural' primary key
fields in
> the UD table to associate the OrderDtl table.
>
> To establish and FKV, you often have to create a chain of related
FKV's
> to finally make the relationship available that is necessary to add
the
> FKV of the table you are really interested in.
>
> FKV's are a capability which you would expect to make things very
simple
> (to produce powerful, hybrid customizations) - but it is often much
more
> trouble than it is worth to explore (via trial and error - as there
> seems to be little logic behind it) the myriad of potential chained
FKV
> paths that might allow you to reach and tie into your table of
interest.
>
> Perhaps someday Epicor will document it (much) better to negate the
> potential for wasting development time on what proves to be a dead
end.
>
> gyorkillinois <gyork@... <mailto:gyork%40aqua-aerobic.com>
> > wrote:
> I would like to add some UD fields to a custom sheet in Sales Order
> Entry. I am trying to create a foreign key view linking the UD
table to
> the OrderDtl table. I have added the UD table to a menu as required
but
> don't see the UD table in the list of data sources in the foreign
key
> view build area. We have Vantage 8.03.403D. Does anyone have any
> suggestions?
>
> Gary York
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
Try it now.
>
> [Non-text portions of this message have been removed]
>
7
Good luck with you project Gary.Once you get through the learning curve, things will start to come together much faster.

If you don't already have it, I strongly recommend you purchase the "Epicor Tools User Guide" as it is at least an order of magnitude improvement over the help files and, other than lacking an index (?!?!?) it is very easy to navigate & to make immediate use of.

I've also found it handy to have excel file open and actively connected to the db using open edge 10b odbc. It helps to determine when data is actually updated (and which fields in which related tables) upon any application event trigger. Doing so really narrows the focus upon a few possible event triggers (that are apt to result in a high rate of sucess) to build you code around.

If you find any new UD table programming resources, please pass them on. I still feel integrating UD (or existing table) views into existing apps is by far the most potentially powerfull customization basis going for 403. ...If Epicor would just completely document it.

Rob
gyorkillinois <gyork@...> wrote:
Robert/Stephen,

This explains why I wasn't having success with the solution in the
Help topic. Thanks for pointing me in the right direction. I'll reply
with my results.

Gary York
Aqua-Aerobic Systems

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> Under 305i & 403c, the code out of the help file doesn't function
until you tweak it a little. (If I remember correctly, their are some
syntax typos.)
>
> You still need to add the UD custom assemblies needed (and that
isn't mentioned in the help file - or Epicor Tools User Guide) at all.
>
>
>
> Stephen Edginton <stephene@...> wrote:
> Gary / Robert
>
> Just as a note,
>
> If you search for "UDXX" in the help there is a document
> titled "How can a user-defined table become a foreign key view
option?"
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Robert Brown
> Sent: Wednesday, December 19, 2007 5:59 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Using a UD Table in a Foreign Key View
>
> Did you add the necessary custom assemblies to your customization
(to
> make the UD adapter accessible)?
>
> Assuming that is the step missed, you still will likely have
difficulty
> adding the UD table as and FKV. (It is much easier to code directly
and
> bring it in as a DataView.) There are no 'natural' primary key
fields in
> the UD table to associate the OrderDtl table.
>
> To establish and FKV, you often have to create a chain of related
FKV's
> to finally make the relationship available that is necessary to add
the
> FKV of the table you are really interested in.
>
> FKV's are a capability which you would expect to make things very
simple
> (to produce powerful, hybrid customizations) - but it is often much
more
> trouble than it is worth to explore (via trial and error - as there
> seems to be little logic behind it) the myriad of potential chained
FKV
> paths that might allow you to reach and tie into your table of
interest.
>
> Perhaps someday Epicor will document it (much) better to negate the
> potential for wasting development time on what proves to be a dead
end.
>
> gyorkillinois <gyork@... <mailto:gyork%40aqua-aerobic.com>
> > wrote:
> I would like to add some UD fields to a custom sheet in Sales Order
> Entry. I am trying to create a foreign key view linking the UD
table to
> the OrderDtl table. I have added the UD table to a menu as required
but
> don't see the UD table in the list of data sources in the foreign
key
> view build area. We have Vantage 8.03.403D. Does anyone have any
> suggestions?
>
> Gary York
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile.
Try it now.
>
> [Non-text portions of this message have been removed]
>






---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

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