AnsweredAssumed Answered

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

Question asked by hferrell on Mar 6, 2015
Latest reply on Mar 6, 2015 by 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.

Outcomes