does multi reference field will hamper the performance if we create it in sys user table?

[sharyuw]

we need to create custom table to send , receive data from azure, can we use multi reference field in sys_user table which we take from custom table

[Dominik Simunek]

You can create List field to reference multiple records from the custom table. The impact on performance depends mostly on how you are going to use it in queries, lists etc.

You can consider also M2M table between sys_user and the custom table.

The decision depends a bit on the way how you plan to use the data (visualize it, query it, maintain it, edit rights to it).

[adityahubli]

Hello @sharyuw ,

Yes you can . You just need to use List datatype which helps to get multiple records like users,group.

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya,

Technical Consultant