Loose Ends

We created grids on forms but were unable to drill down until other forms were created.

Nationality Form

Open form designer and click on the grid to set the drill down from the National Team Players grid to both the footballer and club forms:

Club Form

Open form designer and click on the grid to set the drill down from the Footballer Players grid to the footballer form.

Footballer Search Form

Open form designer and click on the grid to set the drill down from the footballers grid to additional forms.

Nationality Name Column

Add a drilldown column.

Choose the NationalityName column and hyperlink this via the NationalityID key column name to the Nationality form:

Team Name Column

Add a drilldown column.

Choose the TeamName column and hyperlink this via the TeamID key column name to the Club form:

After adding the additional 2 drill down columns, your Grid component properties should look like this:

Apply

Apply the changes, then Save the form design to persist.

Test

You should now re-open the Footballer Search form to test that drill down works for both nationality and club/team: