Fetch data from table with one to many relationship

How to insert or fetch into Table(CDT) which is having one to many relationship with another table
I have two CDT as country & State where Country to state is 1-to-Many relationship.

Country CDT is having three column (Country ID as key (auto generated),Country Name ,State(as States CDT type))

States CDT is having three column(State id as key(auto generated),State name, country Id)

Note-: There is no foreign key constraint defined in the CDTs.

Issue-: I need to have multiple values for State column in Country CDT. But while updating or adding new state it is overriding all existing value with the new one.

For e.g. Country is having following values

(1,India,{1,UP,1}).

i want to add new state with values {2,MP,1} so that resultant will have (1,India,{{1,UP,1},{2,MP,1}})

i want to achieve this by utilizing the in build features of 1-to-Many relation in tables. So that while doing Update process via Related Action on Entity backed record it wil...

OriginalPostID-130871

OriginalPostID-130871