Hi All
I am trying to build a search results page for the user.
In the database we have three tables
Employees
Empname - Text
Fullname - Text
Records
Id - Autonumber
Subject - Text
Description - Text
Record Dependents
RecordId - Integer
Username - Text
In record dependents there could be multiple values for each recordid
basically it specifies who is allow to view a particular record.
What I need help with is how do a search that will find what the user has
specified but only bring back results for which he is a RecordDependent.
Can this be done through simple sql? or do I need something more.
I was thinking more on the lines of
"Select * from records where exists (Select * from recorddependents where
empname = '8877YYYY') and description ='" & request.form("description") &
"'"