i have tblScrutiny ,

COLUMNS:

teamid
name
userid

now confusion is that every team has many members, so how how would i mention them, like e.g i mention 1 member in teamid =1 , then in next row the teamid changes (identity=ON) , so how to mention 2nd member ?

Sorry, can you elaborate a bit more for clarity?

hi jorgem, i solved it
just added another table, tblMembers

Ok, glad to hear you resolved your issue.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.