check

Relationship Quiz

How well do you know relationships?

Click the button below to start.

Start

Question 1 of 20

What is a key field? (select the best answer)

A

The most important field in a table

B

A field that contains a unique identifier for each record in the table

C

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

A binding agent. Used to join two tables together.

B

A field used in place of the key field. Used to more easily identify the record.

C

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)

A

To provide a temporary look at the type of data a field can store.

B

To capture a lookup field's value and not change if the lookup value changes in the future.

C

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?

A

Using a lookup field.

B

Using a snapshot field.

C

Using a summary field.

Question 5 of 20

How do you display information from a child on a parent?

A

Using a summary field.

B

Using an aggregate field.

C

Using a proxy field.

Question 6 of 20

How do you change a table's key field?

A

In the new key field's properties under the advanced settings.

B

On the left (parent) side of a relationship.

C

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?

A

The child records are updated to use the new key and the old key becomes a lookup field.

B

The child records become orphans and the old key is deleted.

C

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)

A

Yes, when you need both field types.

B

No, it is redundant to have both on the form.

C

Only if one is set to read-only.

Question 9 of 20

What is a record picker used for?

A

When you don't have any good music to listen to.

B

When you need to select a parent record from a list.

C

When you are deleting multiple records and need to select them.

Question 10 of 20

Where do you update the default record picker?

A

In the table's advanced settings.

B

In the record picker field settings.

C

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)

A

In a table report, a chart, or dashboard.

B

As child records, as unrelated records, or as parent records.

C

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?

A

None, report links are only used on dashboards & homepages.

B

Up to 9, with 3 per row.

C

As many as you want.

Question 13 of 20

Is a relationship required for a report link to display records on a form?

A

Yes

B

No

Question 14 of 20

What happens when you delete a table that has relationships to it?

A

The table is archived so that the relationship remains intact.

B

Both tables are deleted.

C

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?

A

Their values are automatically converted to plain fields (text, numeric, etc).

B

Their values become null/empty.

C

They are automatically deleted along with the relationship.

Question 16 of 20

How many 'cascading' conditional dropdowns can a form have?

A

It depends on the number of tables in the app.

B

It depends on the number of relationships in the app.

C

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)

A

Using the right (child side) of a relationship OR using the 'same row' option in the form's elements.

B

Using a multiple-choice field with a related reference field OR using two related reference fields.

C

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?

A

By using a report as the record picker with the filter built into the report.

B

By deleting records that you don't want to appear in the dropdown.

C

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?

A

True

B

False

Question 20 of 20

True or false, you can use a formula as a related reference field? 

A

True

B

False

Confirm and Submit