How well do you know relationships?
Click the button below to start.
Question 1 of 20
What is a key field? (select the best answer)
The most important field in a table
A field that contains a unique identifier for each record in the table
A field that combines with a 'lock' type field
Question 2 of 20
What is a proxy and how is it used on forms?
A binding agent. Used to join two tables together.
A field used in place of the key field. Used to more easily identify the record.
A field that references a URL. Used to link to another record.
Question 3 of 20
Why would the snapshot field setting be used? (select the best answer)
To provide a temporary look at the type of data a field can store.
To capture a lookup field's value and not change if the lookup value changes in the future.
To create a copy of another field's value that can be used outside the app.
Question 4 of 20
How do you display information from a parent record on a child?
Using a lookup field.
Using a snapshot field.
Using a summary field.
Question 5 of 20
How do you display information from a child on a parent?
Using an aggregate field.
Using a proxy field.
Question 6 of 20
How do you change a table's key field?
In the new key field's properties under the advanced settings.
On the left (parent) side of a relationship.
On the table's list of fields, using the 'set key' button.
Question 7 of 20
What happens to related records when a key field changes?
The child records are updated to use the new key and the old key becomes a lookup field.
The child records become orphans and the old key is deleted.
Nothing, you cannot change a key field after relationships are built.
Question 8 of 20
Should a proxy and related reference field both be included on a form? (select the best answer)
Yes, when you need both field types.
No, it is redundant to have both on the form.
Only if one is set to read-only.
Question 9 of 20
What is a record picker used for?
When you don't have any good music to listen to.
When you need to select a parent record from a list.
When you are deleting multiple records and need to select them.
Question 10 of 20
Where do you update the default record picker?
In the table's advanced settings.
In the record picker field settings.
In the default report settings.
Question 11 of 20
What are the different ways report links can be displayed on a form? (select the best answer)
In a table report, a chart, or dashboard.
As child records, as unrelated records, or as parent records.
As a link to the records, displayed as a report/chart, or in an editable report.
Question 12 of 20
How many report links can you have on a form?
None, report links are only used on dashboards & homepages.
Up to 9, with 3 per row.
As many as you want.
Question 13 of 20
Is a relationship required for a report link to display records on a form?
Question 14 of 20
What happens when you delete a table that has relationships to it?
The table is archived so that the relationship remains intact.
Both tables are deleted.
A "ghost relationship" remains connected to summary and lookup fields.
Question 15 of 20
What happens to lookup/summary fields when you delete a relationship?
Their values are automatically converted to plain fields (text, numeric, etc).
Their values become null/empty.
They are automatically deleted along with the relationship.
Question 16 of 20
How many 'cascading' conditional dropdowns can a form have?
It depends on the number of tables in the app.
It depends on the number of relationships in the app.
It depends on how the conditional dropdowns are constructed.
Question 17 of 20
What are 2 different ways to create a conditional dropdown? (select the best answer)
Using the right (child side) of a relationship OR using the 'same row' option in the form's elements.
Using a multiple-choice field with a related reference field OR using two related reference fields.
Using a proxy field with a multiple-choice field OR using a proxy with a multi-select field.
Question 18 of 20
How do you pre-filter selections in a dropdown record picker?
By using a report as the record picker with the filter built into the report.
By deleting records that you don't want to appear in the dropdown.
By adding a filter to the table's default report settings.
Question 19 of 20
True or false, you can choose your own reference field on a child table?
Question 20 of 20
True or false, you can use a formula as a related reference field?