Foreign Key Value on User Defined Tables

Yahoo Archive
1
You need to go to Extended Properties Maintenanec and select the UD20 table and set the Like value of ShortChar01 to be Part.PartNum.
The close / re-launch your epicor and it should give you the drop down


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Apr 9, 2015 at 11:43 AM, Charles Carden shadowcar1449@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Running Epicor 9.702a.  Am trying to set up a Foreign Key Value using <br>

UD20 table into Part table with ShortChar 01 as the key. When I add the

FKV I do not get anything in the Column Name field to select.

Consequently I am unable to add the FKV. Is there something I am doing

wrong or is there a problem with the UD tables and a FKV? I can add a

FKV using non-UD tables without any problem.



Thanks in advance

</div>
 


<div style="color:#fff;min-height:0;"></div>

2
Running Epicor 9.702a. Am trying to set up a Foreign Key Value using
UD20 table into Part table with ShortChar 01 as the key. When I add the
FKV I do not get anything in the Column Name field to select.
Consequently I am unable to add the FKV. Is there something I am doing
wrong or is there a problem with the UD tables and a FKV? I can add a
FKV using non-UD tables without any problem.

Thanks in advance