AnsweredAssumed Answered

Self relationship table occurrence

Question asked by SteveKeiser on Dec 10, 2013
Latest reply on Dec 11, 2013 by SteveKeiser


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.