- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2023 08:41 AM
I am creating a record summary interface but am wanting to use a different field than the primary field in my table for the dropdown to search up a record. Is this possible? Is there a work around? It is difficult to use the primary field in our table for searches as it is a code, it would be much simpler to use a different field.
Thanks!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2023 11:11 AM
So the record is a "code", like "THX 1138", and you want to see something more user friendly like "Robert" in the pull-down menu?
Can you shift the code to another column? Probably the easiest solution I know of. If you're using that code as a reference for linked tables, you can add a look-up field maybe? You can also concatenate the primary record field with a formula that combines your code and the easier to view description.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2023 11:11 AM
So the record is a "code", like "THX 1138", and you want to see something more user friendly like "Robert" in the pull-down menu?
Can you shift the code to another column? Probably the easiest solution I know of. If you're using that code as a reference for linked tables, you can add a look-up field maybe? You can also concatenate the primary record field with a formula that combines your code and the easier to view description.