Look up and post results from related table vs. calculation field.
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.