Hello,

I am creating a solution that keeps track of expenses and calculates the expenses for each month.

I am having problems displaying the name of the selected choice from a value list on a portal. In the solution there are three tables, Expenses, ExpenseCalculation(Main Layout), and ExpenseLine.

I have created a field that uses a value list that collects data from the tables expenses. This data is then stored as a record in ExpenseLine which is reflected on a portal in ExpenseCalculation Layout.

I have been able to catch the value of each expense, but not the name of the expense to pass onto the portal.

Any clues?

Alberto

Hi I still haven't been able to figure out how to do this. I have added the database. Thanks

ExpensesCalcualtion Copy.fp7.zip

I still cannot figure out what are you trying to accomplish here.

I can't quite figure you what you are up to either, but I had a look at your file and it seems like you should be using the PrimaryKey field as the value returned from the value list. If you do this, then you can use it to display the name of the expense.