AnsweredAssumed Answered

Automatically copy and create join records via a portal?

Question asked by user13613 on Apr 10, 2014
Latest reply on Apr 10, 2014 by erolst

I'm trying to use one type of table as a template for another type of table.

For simplied example, here are the tables:

MyBatch

MyBatchXStaticAttributeA

MyBatchXStaticAttributeB

StaticAttributeA

StaticAttributeB

 

MyBatchXItems

MyItems

ItemsXStaticAttributeA

ItemsXStaticAttributeB

 

A Batch is used to group serveral items. I'd like to the Batches relationships to Attributes A and B as a template for newly created items. Basically each different batch should have it's own unique configuration and when an item is created that is related to that batch, I want all that batch's attributes copied over to the new item(this will be used as a default setting for items).

 

I have a layout which uses MyBatch as the base table. In this layout I have a portal for my related Items. I can create a item via the portal but it will not have any join table records created (as is normal). How can I create joins table records for my item records which will copy the batch's information at the time of item creation?

Outcomes