Filling a textbox with multiple data

Renko

Hi

I'm working in a Navision 3.7 database,
I want to fill a textbox with all the entries of one field from one table.
Currently we got a table with the companies, and registered courses.

Example:
Company A participated in 2 courses.
Course 1, worth $50
Course 2, worth $30
Total: $80

So, we need to filter company A from a table and make it walk through the table looking for company A's courses and count the total price of all courses and put that in a textbox.

I hope it's clear to you guys and i hope you can help me soon, i'm pretty in a hurry to get it done. Schoolwork it's called.

markborges

You can look at SETFILTER, SETRANGE and CALCSUMS functions at Navision Developer Guide.