This is for PHPRunner with MySQL database.
I have one table that holds a list of reports:
tblReportMaster with fields ReportID, ReportName
I also have a table of users:
tblUsers with fields UserID UserName.
I have a bridge table that links which users have access to reports:
tblReportBridge with fields BridgeID, ReportID, UserID
In the tblReportBridge ADD screen, there are 2 lookup dropdowns. The first is for the ReportID/ReportName. The second dropdown is for the UserID/UserName.
How do I configure the USER dropdown so it excludes rows where the UserID is already linked to the ReportID?