Related record as number
In view mode, related record appears as a record number but in edit mode, I can choose a record from the drop down. How to show record using field value instead of the record number? I am showing the...
Forum Discussion
The magic here is the use of a Proxy field for the field typically called [Related Parent].
For example, if you have a table of Stores and the key field is [Record ID#], but the [Record ID#] is meaningless to the users. You bring down the Store name in a lookup field on the relationship, and then edit the field properties for the [Related Store] record to select Store Name as the Proxy field.
Then on the form, you use [Store Name] and not [Related Store]. In View mode the field on the form will have as [Store Name], but in edit mode it will behave as [Related Store] allowing the user to select the [Record ID#] of the Parent Store record.
For example, if you have a table of Stores and the key field is [Record ID#], but the [Record ID#] is meaningless to the users. You bring down the Store name in a lookup field on the relationship, and then edit the field properties for the [Related Store] record to select Store Name as the Proxy field.
Then on the form, you use [Store Name] and not [Related Store]. In View mode the field on the form will have as [Store Name], but in edit mode it will behave as [Related Store] allowing the user to select the [Record ID#] of the Parent Store record.
- This trick didn't work at first, but it was my fault. Before finding this solution, I thought the problem was that the field was set to numeric so I changed it to text, thinking it would show the record name and not the number. I ran your trick and it did nothing. I changed the type back to numeric and voila! Thank you!
