Can I have different display values on 2 reference fields that reference the same table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2016 04:57 AM
Can I have different display values on 2 reference fields that reference the same table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2016 06:12 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2016 08:30 PM
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2016 09:49 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2016 10:17 PM
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....