0
Business scenario : I have two entities, Question and Feedback.
Based on answer to each question, supervisor provides feedback to a question.
I am trying to achieve below design, where I can see fields from both the entities in Feedback form. I can't merge

Question Entity Feedback Entity
Question 1 Feedback 1
Question 2 Feedback 2
Question 3 Feedback 3
Question 4 Feedback 4

Feedback form design

Question 1
Feedback 1

Question 2
Feedback 2

Question 3
Feedback 3

Question 4
Feedback 4

Limitations: Due to SQL field limitation, I can have maximum of 1024 columns in a table (1024 fields in CRM entity) and the number of questions are expected to increase.
So, merging fields of both the entities into one entity to achieve this design is not possible.

Category:
STATUS DETAILS
New