Can I have different display values on 2 reference fields that reference the same table?

shrija10
Kilo Contributor

Can I have different display values on 2 reference fields that reference the same table?

6 REPLIES 6

Ken_Michelson
Kilo Guru

I don't believe so. An extended table can have a dictionary override on display value.



Can you describe the business scenario that warrants this?


Hi ,



Suppose I have a custom table "Employee " and I want two reference fields called Address and Postal code which refers to a same table location from where in Address it will take name of location table   and Postal code as postal code of location table... Is it possible to have different display values ?


If you have a reference to a location table, why would you need two reference fields? You should need only one.



If you want to be able to search a single reference field on more than one value, you can do that, but only need one reference field. If you want to display different data elements from the referenced record, you can do that as well.



If you are saying that a person could pick "either an address or a postal code", it seems to me that Address might be somewhat unique, but postal code would be quite repetitive. You would be better off changing Post Code to a choice list and re-using it on your employee table.


You can do it, but as ken said you can use one reference field and have postal code as a string or as a choice list which get auto populated once you execute your code, now it depends on you how you rite the code...for any help rply....