Is it possible to fetch a list of data based on a criteria?

Is it possible to fetch a list of data based on a criteria?

Hello,

I'm new to Zoho Creator, so I'm unsure if its even possible to do so.

So I have 3 forms:

Form Name 1: F.Forms
Form Fields : F.Name

Form Name 2: M.Forms
Form Fields 1 : M.Name
Form Fields 2 : M.Connection

Form Name 3: FT.Forms
Form Fields 1 : FT.Name (Lookup of F.Name)
Form Fields 2 : FT.Connections
Form Fields 3 : FT.MName

What I'm trying to get is when M.Connection has a match in FT.Connections, create an array/list in that same FT.Forms where the M.Name is inputted into FT.MName. And that new list/array repeats the FT.Name.

Would really appreciate if someone could help me out with this!