![]() ![]() It's important to understand what's going on, so let's stop here to review. The Table contains the data you want to analyze in some way the Related Table contains lookup values that will make the reported data more meaningful. (If you're working with a file other than the demonstration file, you might see others listed.) Figure D The Data Model can see both Table objects. You'll find both Table objects listed, as shown in Figure D. In the resulting dialog, click the Table and Related Table dropdowns. Currently, there are no relationships, so the dialog will be empty. To do so, click the Data tab and then click Relationships in the Data Tools group. Once both data sets are Table objects, you can create a relationship between them. With both data sets converted, you're ready to create the relationship between them. Repeat the process to convert the lookup values to a Table and name it ShelfCodesTable. Figure C Name the Table objects so they're easier to work with. I named the original data set ProduceTable.įigure B Convert the data set into a Table.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |