Jump to content

Multi-Line key, need calc to 'extract' related values.


This topic is 3048 days old. Please don't post here. Open a new topic instead.

Recommended Posts

This could be one of those easy ones..?

Two tables.. I have a text field in the Product table, called mlfk_DepartmentIDs, which contains paragraph-delimited numerical Department IDs. That field is then used as the left side predicate of a relationship to the Department table, into the Department table's pk_DepartmentID field (its primary key field). Department table also has a text field called DepartmentName.

From the perspective of Product, I want to show a comma separated list of all DepartmentNames, for each department ID in that multi-line key field, mlfk_DepartmentIDs.

I am familiar with using a Join table, but I want to see if this can be solved with just a calculation of some sort. -I don't want to add more clutter to the graph just to benefit this one necessity. -There won't be more than a maximum 10-12 possible IDs, well below that 125-limit I read about (which probably doesn't matter here anyway).

 

Thanks!

Link to comment
Share on other sites

Hi!

In Product table, create calculation (result is text) with:

Substitute ( List ( departments::departmentName ) ; ¶ ; ", " )

 

Edited by LaRetta
Link to comment
Share on other sites

This topic is 3048 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.