Skip to main content

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.


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 NameData TypeReq.SizeDefault Display Type
TitleTexttrue255_Text
InstructionsTextfalse255_Text
RatingTextfalse255_Text

Recipe Table Fields
Figure 2 - Recipe table fields

Category Table
Field NameData TypeReq.SizeDefault Display Type
NameTexttrue255_Text


Category Table Field
Figure 3 - Category table field

Ingredient Table
Field NameData TypeReqSizeDefault Display Type
NameTexttrue255_Text
PriceFloatfalse8_Float.2

RelationshipRequired
Categorytrue

Ingredient Table Field
Figure 4 - Ingredient table fields

Ingredient Table Relationship
Figure 5 - Ingredient table relationship


RecipeIngredient Table
Field NameData TypeReq.SizeDefault Display Type
SubstituteIngredientTextfalse255_Text

RelationshipRequired
Recipetrue
Categorytrue
Ingredienttrue

RecipeIngredient Table Field
Figure 6 - RecipeIngredient table field

RecipeIngredient Table Relationships
Figure 7 - RecipeIngredient table relationships

ShoppingList Table
Field NameData TypeReq.SizeDefault Display Type
NameTexttrue255_Text

ShoppingList Table Field
Figure 8 - ShoppingList table field


ShoppingItem Table
Field NameData TypeReq.SizeDefault Display Type
PriceFloattrue8_Float.2
QuantityIntegerfalse4_Integer
TotalFloatfalse8_Float.2

RelationshipRequired
ShoppingListtrue
Ingredienttrue

ShoppingItem Table Fields
Figure 9 -ShoppingItem table fields

ShoppingItem Table Relationships
Figure 10 - ShoppingItem table relationships

Substitute Table
Field NameData TypeReq.SizeDefault Display Type
NameTexttrue255_Text

RelationshipRequired
Recipetrue

Substitute Table Field
Figure 11 - Substitute table field

Substitute Table Relationship
Figure 12 - Substitute table relationship