× 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

Hobbes

New Member

Posts: 3

9 years 8 months ago - 9 years 8 months ago #721 by Hobbes

Concatenated field values in foreign keys was created 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 8 months 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.

RIP Graphics

New Member

Posts: 16

9 years 8 months 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.

Walt Sorensen

Senior Member

Posts: 54

9 years 8 months 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.049 seconds