Tuto WEBDEV 25
90 Part 2: My first database 2. In the window that is displayed, modify: • the name of data file: "OrderLine". • the name on disk: "OrderLine". ▶ We are now going to modify the items of this relation file. 1. Click the icon to display the description of file items. 2. This data file has 3 items. Position the selection bar on the "OrdersID_Reference" item. This item is a composite key. Remark A composite key is a set of items that constitute an index. This type of key is used to browse the data file according to complex criteria or to perform specific searches on several items at the same time. 3. To rename this item: • Click the "Name" column. • Replace "OrdersID_Reference" by "OrderLineID". • Click the "Caption" column. • Replace the current caption by "Identifier of OrderLine".
Made with FlippingBook
RkJQdWJsaXNoZXIy NDQ0OA==