Jump to content

Calculating a list with fields from a related database


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

Recommended Posts

  • Newbies

I need help with how to create a field containing a list of items from another database.

I have two databases SUITES and SETS.

The relation between them is a 1-N relation with SUITE_ID::SUITE_ID so that I can get a list of all the sets in a particular suite.

I can of course show the sets in a portal in the SUITE db, but what I want to be able to do is to export the list of sets together with information for each suite. I have tried just exporting the related fields, and they all are there, but the format is wrong.

When I do the export I want the output (in TAB-format) to come out something like this:

SUITE_

SUITE_info1

list=SETS

SUITE_info2

e.g:

0210A1

suite about stuff

list=set1, set2, set3

more info about suite

So what I'm looking for is, I think, some way to create a calculated field that can add all sets matching the SUITE_ID, putting a comma between them.

Is this at all possible?

Any pointers are deeply appreciated.

/Ax.

Link to comment
Share on other sites

  • 1 month later...
  • Newbies

No problem.

Create a value list based on the target field in your related file, be sure to make it based on the relationship. Next create a calculated field equal to the ValueListItems of the value list created. All the data from the field in the related file will be there in CR delimited form. You can Parse this in any way you want

Link to comment
Share on other sites

This topic is 8741 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.