SOLUTION - Create a Lookup with a Products and Services Category List for "Personal Budget"
If you have had difficulties in solving the exercise, in this page you find the step-by-step solution.
-
Create a Blank Storage called
Transactions Products Services
.Transactions Products Services
will record the options for the lookup with all the products and services categories. -
Add to
Transactions Products Services
Storage the following fields:IdTransactionsProductsServices
IdentityName
StringIcon
Icon
-
You now need an application to insert data in
Transactions Products Services
. Create an application called Transactions Products and Services. Customize the appearance of the application's tile if you like. -
There is no need to customize the appearance, you must fill only two fields Name and Icon.
Insert some categories of services and product that you might use in your daily routine with Personal Budget. (E.g. Healthcare, Utilities, Transport).
-
Save all the changes in Transactions Products and Services.
-
In the Storage editor of Transactions, add a Numeric type field
TransactionsProductServiceId
. -
Create a Relation between
TransactionsProductServiceId
andIdTransactionsProductsServices
in Transactions. Call itTransactions_Product_Service_Categories_Lookup
. -
Enter the Design Mode of Personal Budget. Configure the Lookup Relation of
TransactionsProductServiceId
as in the image. Then click on the Confirm button to save the changes. -
Make the
TransactionsProductServiceId
visible in the Master sub-panel. The Relation should resemble the picture below. -
Change the header's label of
TransactionsProductServiceId
toProduct Service
in the Master sub-panel. -
Arrange as you prefer the Product Service column in the Layout. (See the section Customizing the Application's Appearance.)
-
Save all the changes in Personal Budget Design Mode.
Now Personal Budget should look like this:
You have completed the exercise for the Lookups section. Go back to the tutorial.