Security Issue - Duplicate Recordset Results
I am trying to resolve a potential security issue, but when I do, it creates another problem with duplicate recordset results. I thought I had fixed the security problem with a recordset that joins two tables. The security seems to be working ok, but the recordset gives me duplicate results on the "master" page of my master/detail page set.
I have created the following two tables:
1. publishers_us (this table is populated by registration page created with Security Assist)
2. data_us (this table is populated with an insert_data form created with Data Assist)
Each table has a "usEmail" field and a "usPassword" field. I need the values in these fields to match in both tables to create the security I need. Otherwise, it would be relatively easy for a logged in user to submit a bogus article with another uses name attached to it.
I am thinking that my problem lies with my JOIN statement, but I don't know. Any help will be appreciated.
The following recordset is giving me duplicate results.
SELECT publishers_us.usEmail, publishers_us.usPassword, publishers_us.usFirstName, publishers_us.usLastName, data_us.usDocID, data_us.usIssue, data_us.usEntryType, data_us.usEntryTitle, data_us.usIssueDoc
FROM publishers_us INNER JOIN data_us ON publishers_us.usEmail = data_us.usEmail
AND publishers_us.usPassword = data_us.usPassword
WHERE data_us.usIssue = 'Knockout Roses'
Can you please tell me where I am going wrong here? Am I going the wrong direction here?
