Database Reference
In-Depth Information
Figure 12-8.
Data grid result
You also need to create a data grid to keep track of the number of goals each player
scores. You don't have any existing data ready to copy and paste from a spreadsheet, so
this time it makes sense to create the data grid manually. Here are the steps to follow:
1.
Click the
Data Grid
tab at the top of the application.
2.
Click the
New Data Grid
menu option.
3.
Select
From Scratch
as the input method, and click
Next
.
4.
Fill out the data grid definition, as shown in
Figure 12-9
,
and click the
Create Data Grid
button to finish creating the data grid.
Figure 12-9.
Creating a data grid from scratch
Applying Constraints
Now that you have data grids, you need to add some constraints to them. Because data
grids aren't database objects, you must use the websheet interface to apply constraints.
In the Players data grid, you need to ensure that all the fields contain data and that
the default for the Goals column is 0. To apply these constraints, follow these steps:
1.
Click the
Data Grid
tab.
2.
Click
Players
in the drop-down menu.