2 Replies Latest reply on Mar 6, 2015 2:15 PM by hferrell

    Look up and post results from related table vs. calculation field.

    hferrell

      Title

      Look up and post results from related table vs. calculation field.

      Post

      My database has “State” and “County” in different fields.  I would like to retrieve the “RepsName” from the an associated table (not constructed) that will contain states, counties and representative for that county.

      Should I structure a related table for my database that will post a contact name (RepsName).   

      Or should the RepsName be populated by a calculation field? 

      Your suggestions are greatly appreciated.