Members ID linked to Collection

Ask the community
, ,
1

Hi All,

I need some help! I have a Members Collection which is working absolutely fine, and is for parents of a youth football team to sign into. However, I am trying to create a ‘players’ collection which gives u a full database of players across the club, but each player needs to be linked to a Member (parent).

The idea would be that the Site Member (parent) logs in and signs up their child (or children)… then upon next log in, the parents can see their childrens profiles and we (back end data collectors) can see all the information for all parents and children in one place.

How do I link the Member to the Child?

Thanks
Paul

2

  1. Create a “Members” collection: This collection should contain information about the parents (Members) such as their names, email addresses, and any other relevant details. Each Member should have a unique identifier, such as a member ID.

  2. Create a “Players” collection: This collection should contain information about the children (Players) such as their names, ages, positions, etc. Each Player should also have a unique identifier, such as a player ID.

  3. Add a field in the “Players” collection to reference the Member: Create a field in the “Players” collection to store a reference to the corresponding Member. This field can be a reference field or a foreign key field that links to the Member’s unique identifier (e.g., member ID). UPSers Login

  4. Establish the link between Member and Child: When a parent signs up a child, you can use the Member’s unique identifier to establish the link between the Member and the Child. This can be done by setting the reference field or foreign key field in the Child’s record to the Member’s unique identifier.

  5. Retrieve parent-child data: To retrieve the parent-child data, you can query the database based on the Member’s unique identifier. This will allow you to fetch all the children associated with a specific Member.