Query Databse

I don't even know how to explain this in words but here goes.

A user creates a record (name (jay), d.o.b etc), they may create many of these (saved into collection 1)

On another page that same user then creates many records (saved into collection 2)

That same "name" (jay) created in the first instance is brought across to collection 2 because i needed something common linking the 2 collections

I need to now query collection 2 bringing in all information under "jay" (remembering i do not know what this "name" will be called.

I also need to do the same for any other "names" that user creates

Is there a way of doing this?

example:

User1
Jay 01/01/2000 Blue
Bob 02/02/2002 Red

Jay
06/09/2018
12:01 Yes No Blah
13:52 No No Blah
23:59 Yes Yes Blah

Bob
06/09/2018
08:12 Yes No Blah
14:08 No No Blah
20:26 Yes Yes Blah

07/09/2018
16:45 Yes No Blah
20:00 No No Blah

So i need all of Jay's Data shown on Jay's page and all of Bob's Data shown on Bob's page but again, i do not know how many "names" will be created.

Thank you
1 person has
this question
+1
Reply