What's obvious at this point is that you can't turn the data into any meaningful information-at least, not easily. You need the data from all three sheets to pull together a complete sale. None of the sheets alone gives the full picture. Each order in that sheet is related to a customer in the Customers sheet and details about that order in the Order Details sheet. As you can see in Figure A, the data sets are related by common fields:įigure A We'll work with two relationships to combine data from three tables.Įvery record in the Orders sheet represents an order. Our example workbook has three sheets of related data: Customers, Orders, and Order Details (copied from ProductInventory.accdb, an Access database).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |