I have a tabbed report page that uses authentication of logged in user to compare a field in the table (UserID field) that matches. Problem is I have a list of 5 or 6 items that are added for all users and I have set the userID listed as "system" for those items. I cannot figure a way to use the OR function with the authentication check to pull the records that are "system" as well as the auth userID check. There has got to be an easy way to say authenticated userID OR "system"
Any ideas.. Probably basic.. thanks for helping!!!
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
techguy
I have a tabbed report page that uses authentication of logged in user to compare a field in the table (UserID field) that matches. Problem is I have a list of 5 or 6 items that are added for all users and I have set the userID listed as "system" for those items. I cannot figure a way to use the OR function with the authentication check to pull the records that are "system" as well as the auth userID check. There has got to be an easy way to say authenticated userID OR "system"
Any ideas.. Probably basic.. thanks for helping!!!
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.