Tuto WEBDEV 25

88 Part 2: My first database 8.  This step defines the integrity rules that will be automatically applied. In our case, you have the ability to choose the requested behavior when deleting a customer as well as the requested behavior when modifying the customer identifier. 9. Validate the integrity rules by going to the next step of the wizard. 10. Click "Finish". The link is automatically created in the data model editor. ▶ Likewise, create a link between the "PaymentMode" and "Orders" data files. These two data files are linked as follows: • An order must have a payment mode. • A payment mode can be used in several orders. In the wizard: • The cardinalities are as follows: PaymentMode (0,n), Orders (1,1). • The link key corresponds to the "Code" item. ▶ We are now going to create a link between the "Orders" and "Product" data files. This link will be used to create a link file, the data file of order lines. 1.  Likewise, create the link between the "Order" and "Product" data files. 2. Answer the questions asked by the wizard: • Each Order has at least one Product: No • Each Order can have several Products: Yes • Each Product has at least one Order: No • Each Product can have several Orders: 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.