Self relationship table occurrence
I have three separate tables which share some information. I have all employees in a contacts table. All sales reps are in the employees table. To simplify making changes, I added fields for Sales Rep and Employee to the Contacts table, and global fields with values to equal the value for Sales Rep and Employee thinking I could use table occurrences with self relationships to separate out a list of sales reps and employees that can be pulled into various other tables when needed and to use in value lists. The problem is I can't figure out how to do this.