coherentkris

Issue with value lists

Discussion created by coherentkris on Sep 13, 2013
Latest reply on Sep 24, 2013 by Stephen Huston

A coworker and I discovered an issue with value lists and popups.

 

if you have table 1 that has:

pk recid value

1 2 abe

2 4 abe

3 1 beth

4 5 joe

5 6 mary

 

and table 2

pk fk

1 1

2 2

3 4

4 5

 

and a pop up control on a layout based on table 2 with the values from table 1 pk and value list, show only value

 

the records for fk show

abe

2

joe

mary.

 

It's easier to explain if you look at the attached file.

any suggestions on how to deal with this issue?

 

Thx,

Kris

Outcomes