# Relation for registration - need help **URL:** \ **Category:** Ask for Help\ **Created:** [October 21, 2023, 9:13am UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167 "2023-10-21T09:13:03Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![stephane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stephane/32/65527_2.png) [@stephane](https://community.glideapps.com/u/stephane)\ **Post date:** [October 21, 2023, 9:13am UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/1 "2023-10-21T09:13:03Z")
HI, I would like to create an app for registration. The problem is I ceate relation in User table, Registration and event but it is not working. The final statement I would like to get is for 1 user multiple registration. For an envent, multiple users and registration… Thank you ---
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [October 21, 2023, 5:45pm UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/2 "2023-10-21T17:45:27Z")
Do you have row owners enabled in your user table? In this case you need 3 tables 1. User Table 2. Events 3. Registrations Make a relationship between User Table and Registration table to see what events each user has registered Make a relationship between Events table and Registration table to see the list of users attending an event. Everytime when a user registers for an event, you need to create a row in Registrations Table with EventID and UserID. That will help you make relationships. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 22, 2023, 3:26am UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/3 "2023-10-22T03:26:32Z")
> [@Hassan\_Nadeem](#): > > Do you have row owners enabled in your user table? > > In this case you need 3 tables > > 1. User Table > 2. Events > 3. Registrations > > Make a relationship between User Table and Registration table to see what events each user has registered That won’t work. If the User table has row owners applied, then unowned rows will not exist on a Users device. Adding relations won’t magically make them appear. The OP either needs to remove row owners (assuming they are present), or create a separate Public Profiles table with no row owners. ---
**Author:** ![stephane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stephane/32/65527_2.png) [@stephane](https://community.glideapps.com/u/stephane)\ **Post date:** [October 22, 2023, 8:21am UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/4 "2023-10-22T08:21:08Z")
Thank you Guys. I do not have owner ID in the users table. I will review my tables with your comment and let you knowm what is the issue. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 22, 2023, 8:53am UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/5 "2023-10-22T08:53:08Z")
If you can’t figure it out, then if you can show us screen shots of your tables from the Data Editor, and how you are configuring the relation, then we can probably help. ---
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [October 22, 2023, 9:18am UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/6 "2023-10-22T09:18:51Z")
I meant to tell them to remove it if they have enabled it. 😃 ---
**Author:** ![stephane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stephane/32/65527_2.png) [@stephane](https://community.glideapps.com/u/stephane)\ **Post date:** [October 24, 2023, 3:13pm UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/7 "2023-10-24T15:13:17Z")
Hi Guys, Thank you for your reply. With your help I have finally succeeded to record registration to event and users. Now, I a am facing another problem because I person can registrer twice or more to the same event…Rrrrrrh I tried some conditons when trying to regiser but it does not work. here you are some pics : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2b3c2d436fd1e3a29168bcf579d5cc38ad2fa9e5.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/ba53a582b430d8f8c45502f9517b7c4445bc0937.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/799e2f5d5bb25aeba5700211e8e2d7a94bf3c254.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b61e6f57e7a1b758105d70a832bf6b792a9a017.png) If you see something wrong, or should be different, let me know. Thanks Stephane ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 24, 2023, 3:22pm UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/9 "2023-10-24T15:22:52Z")
Can you show me a screen shot of your registrations table please? Most likely you just need to create a Query column from your users table, and then prevent submission when that isn’t empty. If I can see the structure of the table, I can probably give some more specific guidance. ---
**Author:** ![stephane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stephane/32/65527_2.png) [@stephane](https://community.glideapps.com/u/stephane)\ **Post date:** [October 24, 2023, 4:24pm UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/10 "2023-10-24T16:24:36Z")
here you are the eregistration table 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08d9f3c2459c440c6a30be3c4ec021b93e36a7e3.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 25, 2023, 12:14am UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/11 "2023-10-25T00:14:08Z")
Create a query in your events table, target the participations table and filter by: - Event ID is this row \> Row ID - Email is signed-in user If the query is not empty, hide the registration button. ---
**Author:** ![stephane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stephane/32/65527_2.png) [@stephane](https://community.glideapps.com/u/stephane)\ **Post date:** [October 25, 2023, 5:18pm UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/12 "2023-10-25T17:18:44Z")
I tried to do this but seams not working. Note that I manually wrote “signed-in user” because I do not see a possible selection for this. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20ae666e9e321a90304c50f9ca67488bc4fb092d.jpeg) and as you can see, I can register twice or more. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a90409e3b79b5b5dd98dc8ba63c396ced106182f.jpeg) ---
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [October 25, 2023, 8:16pm UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/13 "2023-10-25T20:16:20Z")
![HELP EMAIL](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/90d085721a7485b2767c56183eead8f0f9d4c9ab.png) Do it like this > [@stephane](#): > > Note that I manually wrote “signed-in user” because I do not see a possible selection for this. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 26, 2023, 3:13am UTC](https://community.glideapps.com/t/relation-for-registration-need-help/67167/14 "2023-10-26T03:13:51Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/97efba17450d3eb8c37443631b8e6454507ca4d7.png) You should see an option like this. Can you check again?