Tuto WINDEV 25
112 Part 3: My first database ▶ We are now going to create a link between the "Product" and "Orders" data files. This link will be used to create a link file, the file of order lines. 1. Likewise, create the link between the data files. 2. Answer the questions asked by the wizard: • Each Product has at least one Order: No • Each Product can have several Orders: Yes • Each Order has at least one Product: No • Each Order can have several Products: Yes 3. Go to the next step. The wizard proposes to create a relation file. Keep "Create the relation file automatically" and go to the next step. 4. The wizard proposes the unique key of the Product data file. Select "Reference". Go to the next step. 5. Validate the key creation by going to the next step. 6. Keep the default options regarding the integrity rules and go to the next step. 7. The wizard proposes the unique key of the Orders data file to use: "OrdersID". Go to the next step. 8. Validate the key creation by going to the next step. 9. Keep the default options regarding the integrity rules and go to the next step. 10. Click "Finish". The relation file is automatically created in the data model editor.
Made with FlippingBook
RkJQdWJsaXNoZXIy NDQ0OA==