How do you build relations with imported Creator main and subform data?

How do you build relations with imported Creator main and subform data?

Zoho Creator parent form records that contain subform data store the subform record ID's in a multi-line or memo type field with commas delimiting the subform ID's.


The normal SQL database way would be to wright the parent form ID to the child/subform record and relate it that way, but Creator doesn't do that.

So how can I do relational queries with Zoho creator data between a parent and subform?