Hello all
I have three tables
[Users]
user_id
user_name
[Groups]
group_id
group_name
[Task]
task_id
task_desc
assigned_to (should contain an id which can be user_id or group_id)
The problem is i want to enforce referential integrity on the assigned_to
field in the TASK table.
Obviously a foreign key can refer to only one table. Is there a way to
solve this issue without creating another table containing the records from
the USERS and GROUPS tables ?
Thanks
Manish
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
