Display Lookup Table Value in List View

This topic is locked

Display Lookup Table Value in List View	7/29/2007 10:47:59 AM
PHPRunner General questions
D Devon author This is probably simple and I am missing it. I use lookup tables for several fields of form. For example, I stire a salesperson's ID in the actual order form, but use a lookup table so that when a human has to interact with the form (add or edit) they select by name and teh form stores the ID. In list view, however,it shows the stored value of ID and does not show the corresponding lookup table value. How do I display the lookup value instead of the actual stored value?


D	Devon author 7/29/2007
	This is probably simple and I am missing it. I use lookup tables for several fields of form. For example, I stire a salesperson's ID in the actual order form, but use a lookup table so that when a human has to interact with the form (add or edit) they select by name and teh form stores the ID. In list view, however,it shows the stored value of ID and does not show the corresponding lookup table value. How do I display the lookup value instead of the actual stored value? Ok. I found the problem. It only happens when the stored value does not exist in the lookup table. I corrected that and now it works properly.