Updatable Foreign Key View

There isn't a 'code-free' way to do it, but if you don't mind writing a bit
it isn't too hard.

The easiest way is to use the customization wizard to add a UD table as a
child. After it wires up the UD table you can change the code to point to
any table you like.

Use a find/replace to swap UDXX for whatever table/BO you want and that
will fix a lot of the code automatically. However, you'll still need to
make a number of changes to get it all working. Just do that and run the
'test code' function. You'll get a TON of errors, but don't be discouraged.
Just go through them one by one and you'll get there.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Fri, Oct 5, 2012 at 12:31 PM, supertico05
<mvissuet@...>wrote:

> **
>
>
> Is there a way to create an Updatable Foreign Key View on Epicor 9.05.606?
>
>
>


[Non-text portions of this message have been removed]
I have created a foreign key view and than created a Sub Table View. I
was successful in getting data the way I wanted. I am displaying that
data in a ultra grid, but I cannot paste insert or paste update into
that grid. Can someone help me in achieving that. Thanks for the help
in advance.

Dhaval Jariwala(DJ).
From waht I have been told, you cannot update FKVs. I was trying to do
the same and tech support said that it was not possible.


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation


Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jariwala_dhaval
Sent: Monday, August 11, 2008 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updatable Foreign Key View



I have created a foreign key view and than created a Sub Table View. I
was successful in getting data the way I wanted. I am displaying that
data in a ultra grid, but I cannot paste insert or paste update into
that grid. Can someone help me in achieving that. Thanks for the help
in advance.

Dhaval Jariwala(DJ).






[Non-text portions of this message have been removed]
Is there a way to create an Updatable Foreign Key View on Epicor 9.05.606?