Please, I want to create new app used in food delivery.
One of the app field contain Enumlist for food types e.g (field#1), another field contain Enumlist for food prices (field #2), and 3rd field is (field #3) to summation the total cost of menu.
My question is how to connect those fields above? Where the app will record the price of food automatically (in field #2) when customer record in field #1? Also I want to take consideration if the customer record more than 2 types of food in (field #1).
Thanks for all
Soโฆ you would like to sum costs when the user has chosen foods with the field #1?
Thank you Aleksi.
If the customer request many types of food from Enumlist in (field#1) and (field#2) contain the prices of each type of food.
And I want to make field (field#3) will automatically calculate the cost of requested food. And thus how to connect those fields.
Are you reading foods and prices from another table?
From same table.
I mean do you read for example foods from another table?
Yes.
Then you can sum prices like SUM(SELECT(TableName[Price],IN([Food],[_THISROW].[Food])))
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |