I have a database “Users”, and another one “Gender”. The relationship between those two seems to be OK.
The “Gender” database contains Male and Female records. By creating a profile, a user must choose between those 2 options in a drop down list. By clicking “Create profile”, the “Users” database is updated.
Later on, I want to display the profile inforamtion but Using Magic Text, I cannot choose the record filled by the “Gender” database. In the “Logged in User’s”, I only see Users record, and not Genders records.
What’s the type of the relationship you created between the Users and Genders collections? One to Many right? ( A user can have only one gender and a gender can have many users )
Could you share some screenshots of your Users and Genders collections?