Insert into table

[hahii]

I have two tables. Roles and Users. In Roles I have three columns iID(PK

[David Mujica]

I think your design is missing a table. Typically this type of situation is implemented as follows: Users table (contains a list of valid users) Roles table (contains a list of valid roles) RoleMembership (this shows which users are associated with which roles) For example: Users: A,B,C Roles: R1, R2, R3 Role Membership A,R1 A,R2 B,R1 C,R1 C,R3