JohannPatrickTa
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: HELP NEEDED with matching fields
Samples of entry in "Security Center" Table ,"Issue" field. (rich text) Issue: User XR2323 has an external authentication. Samples of entry in Table "Site Users", which has a field User ID (text). User ID: XR2323 Login ID: xxxxxx User Group: KU Account Status: Active ------------------------------ JohannPatrick Tan ------------------------------0Views0likes0CommentsHELP NEEDED with matching fields
I have a following problem in one of my QB tables and I was hoping you could assess, if this can be solved with QB tools / features. Table "Security Center" has a field Issue(rich text), which looks like below. Table "Site Users", which has a field User ID (text). My objective is to "flag" or "mark" a record in Security Center, if Issue has User ID, which matches a User ID in Site Users table. Is this doable with QB using the current data structure and how? Appreciate your help. ------------------------------ JohannPatrick Tan ------------------------------1View0likes3Comments