Hi,
I have an old database layout that is still being used and i need to change the design.
I have 2 tables.
COM, USERS.
COM has a 'managedBy' field which contains a foreign key from USERS.
USERS has the following fields,
'id','username','access','active'.
At the moment USERS.id is a...