can we have two recipient tables in ACM?

[Qurio]

How difficult is it to split existing recipient table into two recipients based on value under a particular field?

Once split will it it be possible to make workflows for both recipients using the same data in other tables in the Acm db without having to replicate these tables for the second recipient? 

[Milan_Vucetic]

Hi @Qurio

you can set up a custom Recipient schema.

Check it here.

Regards,

Milan

[Qurio]

Thanks Milan for the information. The page talks about setting up a custom recipient table. it also mentions an extension table which will by default have out of box functionality linked.

I feel that if an extension table is used it would be ok for my requirement as all out of box functionalities will come along with that. My question on that (for which i could not find any resources online) is 

1. will we able to define access to users separately for this table or will it take the access levels defined in the original recipient table.

2. Will this extension table still be linked with all other tables in the schema.

3. will we have to run a separate instance of ACM for this or not?

if you could point me to where i can learn more about this would be helpful.

[Sukrity_Wadhwa]

Hi @Milan_Vucetic, Could you please help @Qurio further with their query? Thanks!

[Milan_Vucetic · Accepted solution]

Hi @Qurion, there is not such documentation. 1) You can define this on schema itself with sysFilter (link) 2) Table extension means you changing someting in existing table and links will be there. If you set up a new table you must define link keys for tables you want to have link. 3) You do not need separate instance.

Regards,

Milan