![]() If you choose to Create the relationships yourself then the Create Relationship menu will open. ![]() Small tables and consistent field names between tables will help Auto-Detect to work. With this simple relationship, Excel is easily able to create the relationship. If you choose Auto-Detect, Excel will work to create the relationships and you can check the results by pressing the Manage Relationships button or just Close the window. From here you can select Auto-Detect and let Excel guess the relationships between your tables or you can Create them yourself. A notice will appear above the field list saying Relationships between tables may be needed.Drag the Total field from the Orders table to the Values area. ![]() Expand the table to see fields by clicking the arrow next to the table name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |