Excel’s Data Model creates a relationship between two ... Fortunately, it’s easy: Name the Table objects so they’re easier to work with. Repeat the process to convert the lookup values ...

click the LicenseNumber and Name checkboxes. Select fields from the Master1 Table and fields from the Violations table for this report. Note: Excel knows which field is the key field, because you ...