MacB Posted September 13, 2006 Share Posted September 13, 2006 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 More sharing options...
Fei Posted September 13, 2006 Share Posted September 13, 2006 Create a calculation field and use the " & " function. Link to comment Share on other sites More sharing options...
MacB Posted September 13, 2006 Author Share Posted September 13, 2006 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 More sharing options...
Recommended Posts
This topic is 6570 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 accountSign in
Already have an account? Sign in here.
Sign In Now