clarification.
From: Daddio <no_at_sorry.com>
Date: Thu, 09 May 2002 23:26:30 GMT
Message-ID: <GADC8.8955$fH5.8573699_at_kent.svc.tds.net>
PK = Role_ID + Screen_ID
FK = Screen_ID
PK = User_ID + Screen_ID
FK = Screen_ID
PK = Screen_ID
Date: Thu, 09 May 2002 23:26:30 GMT
Message-ID: <GADC8.8955$fH5.8573699_at_kent.svc.tds.net>
I omitted a sample record from tblScreen as well as the referentrial integrity constraints information. Sorry
Screen_ID Screen_Name
4 Vendor Maint
Referential Integrity
tblRole_Access
PK = Role_ID + Screen_ID
FK = Screen_ID
tblUser_Access
PK = User_ID + Screen_ID
FK = Screen_ID
tblScreen
PK = Screen_ID
Sample output. Does tblUser_Access.User_ID = 4 match with an existing Role_ID in tblRole_Access?
-- Mitch Abaza mitch_at_SPAMmabaza.comReceived on Fri May 10 2002 - 01:26:30 CEST