× This forum has been locked. Please submit new Feature Requests on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Concatenated field values in foreign keys

9 years 1 month ago - 9 years 1 month ago #721 by Hobbes
When creating foreign key references to other tables, it would be terrific if multiple fields related to the same ID could be concatenated.  For example, I have a table that contains a list of individuals detailed by first name, surname and year group.  Listing any one of these fields may not be sufficient - but 'year_group + first_name + surname' is a much more powerful combination for selecting, filtering and listing.

Thanks in advance for any consideration.
Last edit: 9 years 1 month ago by Hobbes. Reason: more appropriate title
The following user(s) said Thank You: RIP Graphics, Walt Sorensen

Please Log in or Create an account to join the conversation.

9 years 1 month ago #734 by RIP Graphics
Replied by RIP Graphics on topic Concatenated field values in foreign keys
+ one

Please Log in or Create an account to join the conversation.

9 years 1 month ago #748 by Walt Sorensen
Replied by Walt Sorensen on topic Concatenated field values in foreign keys
+ one

This is a great feature

Please Log in or Create an account to join the conversation.

Time to create page: 0.124 seconds
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.