Introduction to Five's Lookups

Last updated 21/08/2023

Five's Lookup Display Types

This documentation on lookups is to demonstrate all of Five's lookup display types. As some of the lookups can be quite complex, a sample application has been created for you to follow along with. All the tables you will need are documented below. Five has the following Lookup display types.

• _Lookup
• _LookupBrowse
• _LookupCustom
• _LookupList
• _LookupQuery
• _LookupUnique

Database Model to Demonstrate Five's Lookup Types

To demonstrate Five's lookup display types a basic recipe application called Soul Food will be used. The diagram below is the Soul Food database model.

Figure 1 - Soul Food database model

Soul Food Tables

The tables below show the table configurations to demonstrate Five's default lookup display types. These tables are built with Five's Table Wizard, so the primary key is not created as Five handles this for us.

Recipe Table

Field Name	Data Type	Req.	Size	Default Display Type
Title	Text	true	255	_Text
Instructions	Text	false	255	_Text
Rating	Text	false	255	_Text

Figure 2 - Recipe table fields

Category Table

Field Name	Data Type	Req.	Size	Default Display Type
Name	Text	true	255	_Text

Figure 3 - Category table field

Ingredient Table

Field Name	Data Type	Req.	Size	Default Display Type
Name	Text	true	255	_Text
Price	Float	false	8	_Float.2

Relationship	Required
Category	true

Figure 4 - Ingredient table fields

Figure 5 - Ingredient table relationship

RecipeIngredient Table

Field Name	Data Type	Req.	Size	Default Display Type
SubstituteIngredient	Text	false	255	_Text

Relationship	Required
Recipe	true
Category	true
Ingredient	true

Figure 6 - RecipeIngredient table field

Figure 7 - RecipeIngredient table relationships

ShoppingList Table

Field Name	Data Type	Req.	Size	Default Display Type
Name	Text	true	255	_Text

Figure 8 - ShoppingList table field

ShoppingItem Table

Field Name	Data Type	Req.	Size	Default Display Type
Price	Float	true	8	_Float.2
Quantity	Integer	false	4	_Integer
Total	Float	false	8	_Float.2

Relationship	Required
ShoppingList	true
Ingredient	true

Figure 9 -ShoppingItem table fields

Figure 10 - ShoppingItem table relationships

Substitute Table

Field Name	Data Type	Req.	Size	Default Display Type
Name	Text	true	255	_Text

Relationship	Required
Recipe	true

Figure 11 - Substitute table field

Figure 12 - Substitute table relationship