Create Your First Linked Table

A task tracker has 180 rows and the Customer name is typed manually on every task. “Acme Co” appears as Acme, ACME, and Acme Company. When a repeated value represents a real object with its own attributes, turn it into a linked record. Keeping customer as text feels simpler, but every typo becomes a separate “customer” in reports and lookups. Step 1 Create a Customers table with one record per customer. This gives the business object a home instead of repeating it inside every task. Step 2 Deduplicate customer names before linking tasks. Clean identity first; linking messy names only…

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in