clarification.

From: Daddio <no_at_sorry.com>
Date: Thu, 09 May 2002 23:26:30 GMT
Message-ID: <GADC8.8955$fH5.8573699@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.com

Received on Thu May 09 2002 - 18:26:30 CDT