Filling a textbox with multiple data

Renko
Renko Member Posts: 8
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.

Comments

  • markborges
    markborges Member Posts: 170
    You can look at SETFILTER, SETRANGE and CALCSUMS functions at Navision Developer Guide.

    :wink:
    Marcelo Borges
    D365 Business Central Solutions Architect
    BC AL/NAV C/AL Developer
    BC Repositories.com