Let's begin building a many-to-many table. To do this, perform the following steps in Studio:
- Click Create New Application File, select Table, then Create. Fill out the form, and Save.
- Label: Reservation
- Using the Table Columns related list, add the first date field to the table:
- Column label: Arrival
- Type:Date
- Then add another, as below:
- Column label: Departure
- Type:Date
- Finally, since we want to reserve a room, let's also create a reference field called Room:
- Column label: Room
- Type:Reference
- Reference:Room [x_hotel_room]
- Click Submit to save.
- Then, click Create New Application File, select Many to Many Definition, then Create. Use the following data to fill out the form.
- From table: Reservation ...