USER_ROLES.role_name is foreign key to ROLES.id

[lee yeushian]

Hi,

I had a USER_ROLES table and a ROLES table in my database. (ROLES table is used 
to manage the list of available roles)
The column "role_name" in the USER_ROLES table is a foreign key to ROLES table 
ID column.
Is this possible to workable?
Without the ROLES table, it all worked because it was storing the actual 
rolename instead of the roles.id.

Thanks in advance.

Regards,
Nick Lee