Jump to content

Merging related records in one field


MacB

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

Recommended Posts

Hi there...

I need a bit of help with this....pelase...

We have products in a database. Some are "variants" based on color or whatever. These variants show up in a portal in each of the related records. What i want is this: merge some fields of these (related) records automatically in a field in each of these records...in other words: populate one calculation field with the content of (multiple) related records! Can this be done without scripting?? Thx in advance.

MBahnen, Netherlands

Link to comment
Share on other sites

Well...it's not that simple , i think...

Example: 5 products, all the same NAME, different ordercode and color, so colorvariants. In each of these records you see the others in a portal based on a selfjoin: all with the same name show. I want a (calculation) field in EACH of these records with a merge of portaldata: so regardless which product you pick: you can see the others in ONE single field! Adding a related product would obviously change also the content of that "merge" field...

MacB

Link to comment
Share on other sites

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