Home » Developer & Programmer » Forms » Making Foreign Keys Human readable
Making Foreign Keys Human readable [message #660460] Thu, 16 February 2017 15:31 Go to next message
Messages: 27
Registered: January 2017
Junior Member
What easy ways do exist in Forms to make Foreign Keys human readable?

Like for example an LOV, where you can choose the related values instead of the foreign key.
When I used LOVs you could still see the foreignkey column. Is there a way to change that?

Does Forms give an easy way to replace the foreign key column by the most important columns of the related table but in the background it does still work with the foreign key or would I have to do something like that by myself?

Thanks in advance.

Re: Making Foreign Keys Human readable [message #660463 is a reply to message #660460] Fri, 17 February 2017 00:57 Go to previous message
Messages: 21689
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
When creating a LoV, set foreign key's column width to 0 (zero) and you won't see it.
Previous Topic: Weirdness
Next Topic: TEXT_PARAMETER can not be used ; PARAMETER_ATTR
Goto Forum:

Current Time: Mon Oct 25 00:30:28 CDT 2021