FKV WIth UD Tables

Yahoo Archive
1
In the available Views there is no UD Tables showing.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of melissa hietala
Sent: Thursday, September 02, 2010 4:41 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] FKV WIth UD Tables

Scott -

Yes I was able to get this to work. Here's some instructions:

In customization mode, under data tools, you will first go to the "Custom Column Like" Tab.
Then in the available views choose your UD Table. On the left side under available Columns choose the field you want to link to the other table. You will then click the Edit like property and put in the Data Type(e.g. System.String) then the like column Value for the key to the other table(e.g. JobHead.JobNum) You will then click "Apply Like Property" Click ok then save and close.

Load the customization and go back into the data tools to now create the FKV. Give the view a name and then select your UDTable as the parent.
When you go to choose the column name you should now see your vb fields in there to select.



________________________________
From: Scott Litzau <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Thu, September 2, 2010 3:37:37 PM
Subject: RE: [Vantage] FKV WIth UD Tables


Dustin,

Did you ever get this to work. I would be interested.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
melissa hietala
Sent: Monday, August 09, 2010 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] FKV WIth UD Tables

I created a custom screen in Vantage utilizing the "UD02" table. Is there a
way I can create a foreign key view from the "UD02" table to the Employee
table so that I can display employee information on this particular screen?

Thanks,

Dustin Biniek

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links







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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
I created a custom screen in Vantage utilizing the "UD02" table. Is there a way
I can create a foreign key view from the "UD02" table to the Employee table so
that I can display employee information on this particular screen?

Thanks,
Â
Dustin Biniek




[Non-text portions of this message have been removed]
3
For version 8.03.4xx the simple answer is no. In truth, it can be done, but it
is messy and requires an edit on each workstation. Epicor has some instructions
on how to do it.

When I need to display UD information in a particular screen, I resort to
calling BO objects through the customization and assigning the resulting dataset
as the data source to an ultra grid view. Complicated, but works without having
to modify each workstation.




________________________________
From: melissa hietala <kevmel822@...>
To: vantage@yahoogroups.com
Sent: Mon, August 9, 2010 3:51:50 PM
Subject: [Vantage] FKV WIth UD Tables

Â
I created a custom screen in Vantage utilizing the "UD02" table. Is there a way

I can create a foreign key view from the "UD02" table to the Employee table so
that I can display employee information on this particular screen?

Thanks,
Â
Dustin Biniek

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







[Non-text portions of this message have been removed]
4
I have to respectfully disagree, unless I am missing something. I have FKV to customer, vendor, and a bunch of other tables using UDTables & Forms.
You first need to create a new "Custom Column Like" & then create the Foreign Key View. This is all done using the data tools that you normally use in customization mode.


--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> For version 8.03.4xx the simple answer is no. In truth, it can be done, but it
> is messy and requires an edit on each workstation. Epicor has some instructions
> on how to do it.
>
> When I need to display UD information in a particular screen, I resort to
> calling BO objects through the customization and assigning the resulting dataset
> as the data source to an ultra grid view. Complicated, but works without having
> to modify each workstation.
>
>
>
>
> ________________________________
> From: melissa hietala <kevmel822@...>
> To: vantage@yahoogroups.com
> Sent: Mon, August 9, 2010 3:51:50 PM
> Subject: [Vantage] FKV WIth UD Tables
>
> ÂÂ
> I created a custom screen in Vantage utilizing the "UD02" table. Is there a way
>
> I can create a foreign key view from the "UD02" table to the Employee table so
> that I can display employee information on this particular screen?
>
> Thanks,
> ÂÂ
> Dustin Biniek
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Â
I've never utilized the "Custom Column Like" feature before. Could you give me
a quick description on how to use this?
Â
Thanks
Â

________________________________

From: mmcwilliams22 <mmcwilliams22@...>
To: vantage@yahoogroups.com
Sent: Mon, August 9, 2010 4:06:08 PM
Subject: [Vantage] Re: FKV WIth UD Tables

I have to respectfully disagree, unless I am missing something. I have FKV to
customer, vendor, and a bunch of other tables using UDTables & Forms.
You first need to create a new "Custom Column Like" & then create the Foreign
Key View. This is all done using the data tools that you normally use in
customization mode.

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> For version 8.03.4xx the simple answer is no. In truth, it can be done, but
>it
>
> is messy and requires an edit on each workstation. Epicor has some
>instructions
>
> on how to do it.
>
> When I need to display UD information in a particular screen, I resort to
> calling BO objects through the customization and assigning the resulting
>dataset
>
> as the data source to an ultra grid view. Complicated, but works without
>having
>
> to modify each workstation.
>
>
>
>
> ________________________________
> From: melissa hietala <kevmel822@...>
> To: vantage@yahoogroups.com
> Sent: Mon, August 9, 2010 3:51:50 PM
> Subject: [Vantage] FKV WIth UD Tables
>
> ÂÂ
> I created a custom screen in Vantage utilizing the "UD02" table. Is there a
>way
>
>
> I can create a foreign key view from the "UD02" table to the Employee table so
>
> that I can display employee information on this particular screen?
>
> Thanks,
> ÂÂ
> Dustin Biniek
>
> [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]
6
I would be interested also. Epicor told me you couldn't create a custom column
Like for a UD table using the data tools in 8.03.4xx. It had to do with the
fact that UD tables have five key columns instead of one.




________________________________
From: melissa hietala <kevmel822@...>
To: vantage@yahoogroups.com
Sent: Mon, August 9, 2010 7:43:10 PM
Subject: Re: [Vantage] Re: FKV WIth UD Tables

Â

Â
I've never utilized the "Custom Column Like" feature before. Could you give me
a quick description on how to use this?
Â
Thanks
Â

________________________________

From: mmcwilliams22 <mmcwilliams22@...>
To: vantage@yahoogroups.com
Sent: Mon, August 9, 2010 4:06:08 PM
Subject: [Vantage] Re: FKV WIth UD Tables

I have to respectfully disagree, unless I am missing something. I have FKV to
customer, vendor, and a bunch of other tables using UDTables & Forms.
You first need to create a new "Custom Column Like" & then create the Foreign
Key View. This is all done using the data tools that you normally use in
customization mode.

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> For version 8.03.4xx the simple answer is no. In truth, it can be done, but
>it
>
> is messy and requires an edit on each workstation. Epicor has some
>instructions
>
> on how to do it.
>
> When I need to display UD information in a particular screen, I resort to
> calling BO objects through the customization and assigning the resulting
>dataset
>
> as the data source to an ultra grid view. Complicated, but works without
>having
>
> to modify each workstation.
>
>
>
>
> ________________________________
> From: melissa hietala <kevmel822@...>
> To: vantage@yahoogroups.com
> Sent: Mon, August 9, 2010 3:51:50 PM
> Subject: [Vantage] FKV WIth UD Tables
>
> ÂÂ
> I created a custom screen in Vantage utilizing the "UD02" table. Is there a

>way
>
>
> I can create a foreign key view from the "UD02" table to the Employee table so
>
>
> that I can display employee information on this particular screen?
>
> Thanks,
> ÂÂ
> Dustin Biniek
>
> [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]
7
In the data tools you will first go to the "Custom Column Like" Tab.
Then in the available views choose your UD Table. On the left side under available Columns choose the field you want to link to the other table. You will then click the Edit like property and put in the Data Type(e.g. System.String) then the like column Value for the key to the other table(e.g. JobHead.JobNum)
You will then click "Apply Like Property" Click ok then save and close.

Load the customization and go back into the data tools to now
create the FKV. Give the view a name and then select your UDTable as the parent. When you go to choose the column name you should now see your vb fields in there to select.


If I get some time later this week I can do some screenshots with step by step & upload.

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> I would be interested also. Epicor told me you couldn't create a custom column
> Like for a UD table using the data tools in 8.03.4xx. It had to do with the
> fact that UD tables have five key columns instead of one.
>
>
>
>
> ________________________________
> From: melissa hietala <kevmel822@...>
> To: vantage@yahoogroups.com
> Sent: Mon, August 9, 2010 7:43:10 PM
> Subject: Re: [Vantage] Re: FKV WIth UD Tables
>
> ÂÂ
>
> ÂÂ
> I've never utilized the "Custom Column Like" feature before. Could you give me
> a quick description on how to use this?
> ÂÂ
> Thanks
> ÂÂ
>
> ________________________________
>
> From: mmcwilliams22 <mmcwilliams22@...>
> To: vantage@yahoogroups.com
> Sent: Mon, August 9, 2010 4:06:08 PM
> Subject: [Vantage] Re: FKV WIth UD Tables
>
> I have to respectfully disagree, unless I am missing something. I have FKV to
> customer, vendor, and a bunch of other tables using UDTables & Forms.
> You first need to create a new "Custom Column Like" & then create the Foreign
> Key View. This is all done using the data tools that you normally use in
> customization mode.
>
> --- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@> wrote:
> >
> > For version 8.03.4xx the simple answer is no. In truth, it can be done, but
> >it
> >
> > is messy and requires an edit on each workstation. Epicor has some
> >instructions
> >
> > on how to do it.
> >
> > When I need to display UD information in a particular screen, I resort to
> > calling BO objects through the customization and assigning the resulting
> >dataset
> >
> > as the data source to an ultra grid view. Complicated, but works without
> >having
> >
> > to modify each workstation.
> >
> >
> >
> >
> > ________________________________
> > From: melissa hietala <kevmel822@>
> > To: vantage@yahoogroups.com
> > Sent: Mon, August 9, 2010 3:51:50 PM
> > Subject: [Vantage] FKV WIth UD Tables
> >
> > ÂÂÂ
> > I created a custom screen in Vantage utilizing the "UD02" table. Is there a
>
> >way
> >
> >
> > I can create a foreign key view from the "UD02" table to the Employee table so
> >
> >
> > that I can display employee information on this particular screen?
> >
> > Thanks,
> > ÂÂÂ
> > Dustin Biniek
> >
> > [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]
>
8
The problem I have is that the UD Table is not listed in "Custom Column Like"
tab. I can add it by editing the ContextMenu.XML file, but this is client
specific.
Â
After reading your response, I think I see where the issue lies. I need to ad a
UD table as a FKV to lets say the Order Entry Form. It looks like you are
talking about adding something like JobHead to a UD form. So back to the
original question (which I misread), yes you are right, it can be done.Â
Unfortunately, I usually need to do the reverse.




________________________________
From: mmcwilliams22 <mmcwilliams22@...>
To: vantage@yahoogroups.com
Sent: Tue, August 10, 2010 9:14:22 AM
Subject: [Vantage] Re: FKV WIth UD Tables

Â
In the data tools you will first go to the "Custom Column Like" Tab.
Then in the available views choose your UD Table. On the left side under
available Columns choose the field you want to link to the other table. You will
then click the Edit like property and put in the Data Type(e.g. System.String)
then the like column Value for the key to the other table(e.g. JobHead.JobNum)
You will then click "Apply Like Property" Click ok then save and close.

Load the customization and go back into the data tools to now
create the FKV. Give the view a name and then select your UDTable as the parent.
When you go to choose the column name you should now see your vb fields in there
to select.

If I get some time later this week I can do some screenshots with step by step &
upload.

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> I would be interested also. Epicor told me you couldn't create a custom
>column
>
> Like for a UD table using the data tools in 8.03.4xx. It had to do with the

> fact that UD tables have five key columns instead of one.
>
>
>
>
> ________________________________
> From: melissa hietala <kevmel822@...>
> To: vantage@yahoogroups.com
> Sent: Mon, August 9, 2010 7:43:10 PM
> Subject: Re: [Vantage] Re: FKV WIth UD Tables
>
> ÂÂ
>
> ÂÂ
> I've never utilized the "Custom Column Like" feature before. Could you give
>me
>
> a quick description on how to use this?
> ÂÂ
> Thanks
> ÂÂ
>
> ________________________________
>
> From: mmcwilliams22 <mmcwilliams22@...>
> To: vantage@yahoogroups.com
> Sent: Mon, August 9, 2010 4:06:08 PM
> Subject: [Vantage] Re: FKV WIth UD Tables
>
> I have to respectfully disagree, unless I am missing something. I have FKV to
> customer, vendor, and a bunch of other tables using UDTables & Forms.
> You first need to create a new "Custom Column Like" & then create the Foreign
> Key View. This is all done using the data tools that you normally use in
> customization mode.
>
> --- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@> wrote:
> >
> > For version 8.03.4xx the simple answer is no. In truth, it can be done,
>but
>
> >it
> >
> > is messy and requires an edit on each workstation. Epicor has some
> >instructions
> >
> > on how to do it.
> >
> > When I need to display UD information in a particular screen, I resort to

> > calling BO objects through the customization and assigning the resulting
> >dataset
> >
> > as the data source to an ultra grid view. Complicated, but works without

> >having
> >
> > to modify each workstation.
> >
> >
> >
> >
> > ________________________________
> > From: melissa hietala <kevmel822@>
> > To: vantage@yahoogroups.com
> > Sent: Mon, August 9, 2010 3:51:50 PM
> > Subject: [Vantage] FKV WIth UD Tables
> >
> > ÂÂÂ
> > I created a custom screen in Vantage utilizing the "UD02" table. Is
>there a
>
>
> >way
> >
> >
> > I can create a foreign key view from the "UD02" table to the Employee
>table so
>
> >
> >
> > that I can display employee information on this particular screen?
> >
> > Thanks,
> > ÂÂÂ
> > Dustin Biniek
> >
> > [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]
9
Yes I have the same issue in reverse & will use the adapter.

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> The problem I have is that the UD Table is not listed in "Custom Column Like"
> tab. I can add it by editing the ContextMenu.XML file, but this is client
> specific.
> ÂÂ
> After reading your response, I think I see where the issue lies. I need to ad a
> UD table as a FKV to lets say the Order Entry Form. It looks like you are
> talking about adding something like JobHead to a UD form. So back to the
> original question (which I misread), yes you are right, it can be done.ÂÂ
> Unfortunately, I usually need to do the reverse.
>
>
>
>
> ________________________________
> From: mmcwilliams22 <mmcwilliams22@...>
> To: vantage@yahoogroups.com
> Sent: Tue, August 10, 2010 9:14:22 AM
> Subject: [Vantage] Re: FKV WIth UD Tables
>
> ÂÂ
> In the data tools you will first go to the "Custom Column Like" Tab.
> Then in the available views choose your UD Table. On the left side under
> available Columns choose the field you want to link to the other table. You will
> then click the Edit like property and put in the Data Type(e.g. System.String)
> then the like column Value for the key to the other table(e.g. JobHead.JobNum)
> You will then click "Apply Like Property" Click ok then save and close.
>
> Load the customization and go back into the data tools to now
> create the FKV. Give the view a name and then select your UDTable as the parent.
> When you go to choose the column name you should now see your vb fields in there
> to select.
>
> If I get some time later this week I can do some screenshots with step by step &
> upload.
>
> --- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@> wrote:
> >
> > I would be interested also. Epicor told me you couldn't create a custom
> >column
> >
> > Like for a UD table using the data tools in 8.03.4xx. It had to do with the
>
> > fact that UD tables have five key columns instead of one.
> >
> >
> >
> >
> > ________________________________
> > From: melissa hietala <kevmel822@>
> > To: vantage@yahoogroups.com
> > Sent: Mon, August 9, 2010 7:43:10 PM
> > Subject: Re: [Vantage] Re: FKV WIth UD Tables
> >
> > ÂÂÂ
> >
> > ÂÂÂ
> > I've never utilized the "Custom Column Like" feature before. Could you give
> >me
> >
> > a quick description on how to use this?
> > ÂÂÂ
> > Thanks
> > ÂÂÂ
> >
> > ________________________________
> >
> > From: mmcwilliams22 <mmcwilliams22@>
> > To: vantage@yahoogroups.com
> > Sent: Mon, August 9, 2010 4:06:08 PM
> > Subject: [Vantage] Re: FKV WIth UD Tables
> >
> > I have to respectfully disagree, unless I am missing something. I have FKV to
> > customer, vendor, and a bunch of other tables using UDTables & Forms.
> > You first need to create a new "Custom Column Like" & then create the Foreign
> > Key View. This is all done using the data tools that you normally use in
> > customization mode.
> >
> > --- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@> wrote:
> > >
> > > For version 8.03.4xx the simple answer is no. In truth, it can be done,
> >but
> >
> > >it
> > >
> > > is messy and requires an edit on each workstation. Epicor has some
> > >instructions
> > >
> > > on how to do it.
> > >
> > > When I need to display UD information in a particular screen, I resort to
>
> > > calling BO objects through the customization and assigning the resulting
> > >dataset
> > >
> > > as the data source to an ultra grid view. Complicated, but works without
>
> > >having
> > >
> > > to modify each workstation.
> > >
> > >
> > >
> > >
> > > ________________________________
> > > From: melissa hietala <kevmel822@>
> > > To: vantage@yahoogroups.com
> > > Sent: Mon, August 9, 2010 3:51:50 PM
> > > Subject: [Vantage] FKV WIth UD Tables
> > >
> > > ÂÂÂÂ
> > > I created a custom screen in Vantage utilizing the "UD02" table. Is
> >there a
> >
> >
> > >way
> > >
> > >
> > > I can create a foreign key view from the "UD02" table to the Employee
> >table so
> >
> > >
> > >
> > > that I can display employee information on this particular screen?
> > >
> > > Thanks,
> > > ÂÂÂÂ
> > > Dustin Biniek
> > >
> > > [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]
>
10
Dustin,

Did you ever get this to work. I would be interested.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
melissa hietala
Sent: Monday, August 09, 2010 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] FKV WIth UD Tables

I created a custom screen in Vantage utilizing the "UD02" table. Is there a
way I can create a foreign key view from the "UD02" table to the Employee
table so that I can display employee information on this particular screen?

Thanks,
Â
Dustin Biniek




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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
11
Scott -

Yes I was able to get this to work. Here's some instructions:

In customization mode, under data tools, you will first go to the "Custom Column
Like" Tab.
Then in the available views choose your UD Table. On the left side under
available Columns choose the field you want to link to the other table. You will
then click the Edit like property and put in the Data Type(e.g. System.String)
then the like column Value for the key to the other table(e.g. JobHead.JobNum)
You will then click "Apply Like Property" Click ok then save and close.

Load the customization and go back into the data tools to now
create the FKV. Give the view a name and then select your UDTable as the parent.
When you go to choose the column name you should now see your vb fields in there
to select.



________________________________
From: Scott Litzau <scott.litzau@...>
To: vantage@yahoogroups.com
Sent: Thu, September 2, 2010 3:37:37 PM
Subject: RE: [Vantage] FKV WIth UD Tables

Â
Dustin,

Did you ever get this to work. I would be interested.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
melissa hietala
Sent: Monday, August 09, 2010 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] FKV WIth UD Tables

I created a custom screen in Vantage utilizing the "UD02" table. Is there a
way I can create a foreign key view from the "UD02" table to the Employee
table so that I can display employee information on this particular screen?

Thanks,
Â
Dustin Biniek

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links







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