HELP NEEDED with matching fields

Question

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.
&nbsp;

Table "Security Center" &nbsp;has a field Issue(rich text), which looks like below.
Table "Site Users", which has a field User ID (text).

&nbsp;
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------------------------------

markshnier__you · Answer

Can you provide examples of some Security Issues? Is there a pattern to the data as to where the userid is located?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

johannpatrickta · Answer

Samples of entry in "Security Center" Table ,"Issue" field. (rich text)Issue:&nbsp; &nbsp;User XR2323&nbsp;has an external authentication.Samples of entry in Table "Site Users", which has a field&nbsp;User ID&nbsp;(text).
&nbsp;User ID:&nbsp;XR2323Login ID: xxxxxxUser Group: KUAccount Status: Active
------------------------------JohannPatrick Tan------------------------------

donlarson · Answer

Does this describe you table structure?
In the table Security CenterThe field Related Employee FN is a Formula Numeric Field&nbsp; set it equal to the Related EmployeeNow use Related Employee FN as the Reference Field in the Relationship between the Site Users and Security CenterWhen a record is created in the Security Center, it will be related to the Site Users record that matches the Related Employee in the Issue.Now you can build reports in the Site Users Table for all the Security Issues related to them.------------------------------Don LarsonPaasporterWestlake OH------------------------------

Forum Discussion

HELP NEEDED with matching fields

Related Content

Snapshot Fields

Scheduling Formula needed

Match date to End of Month (EOM) date

Find and Replace Field Values

Proxy fields