Thanks c_o! it works perfectly 😀

just a a few simply questions relating to my actual table which contains 200000+ rows and additional columns I did not include in the sample table.

If wanted to add more groups into EventRole, I would simply use the sql scrip below?

CREATE TABLE [dbo].[Registered]

(

[ParticipantID] INT IDENTITY(1,1) NOT NULL,

[RegisteredInfo] VARCHAR(50) NOT NULL,

[EventRoleID] INT NOT NULL

)

INSERT INTO [dbo].[EventRole] VALUES ('Registered','4')

Do I also need to add every participant level manually? I have 200000+ participant in the table.

INSERT INTO [dbo].[Participants] VALUES ('Person1','1')

INSERT INTO [dbo].[Participants] VALUES ('Person2','1')

INSERT INTO [dbo].[Participants] VALUES ('Person3','2')

INSERT INTO [dbo].[Participants] VALUES ('Person4','2')

ParticipantMap table is simple matching the EventRole to the participant table but is this manually entry also?

INSERT INTO [dbo].[ParticipantMap] VALUES ('1','1')

INSERT INTO [dbo].[ParticipantMap] VALUES ('1','3')

INSERT INTO [dbo].[ParticipantMap] VALUES ('1','4')

Thanks for the help Again!