Alpha Video Training
Results 1 to 4 of 4

Thread: Get sum of child table in grid row

  1. #1
    "Certified" Alphaholic richard2007's Avatar
    Real Name
    Richard Harris
    Join Date
    Sep 2007
    Location
    Ashford, Kent, UK
    Posts
    1,091

    Default Get sum of child table in grid row

    Hi all,

    Using dbf, two tables;

    Cases (parent) - has a field called Case_Value (N)

    Products (child) - has a field called Product_Value (N) - i'd like to total the value of all related records and show the Sum in the parent field


    id like to display a grid based on the parent table records showing the Sum of related child records in the column Case Value.

    ThanksCRM.JPG

  2. #2
    "Certified" Alphaholic richard2007's Avatar
    Real Name
    Richard Harris
    Join Date
    Sep 2007
    Location
    Ashford, Kent, UK
    Posts
    1,091

    Default Re: Get sum of child table in grid row

    I'm not very good at explaining myself so if there is anything else i can add to get some help please shout out.

    i did try using field rules / field events but the tablesum function didn't seem to work for me.

  3. #3
    Moderator
    Real Name
    James A. Talbott, Jr.
    Join Date
    Apr 2000
    Location
    Versailles, KY
    Posts
    1,432

    Default Re: Get sum of child table in grid row

    Did you try dbsum()?

    Here is the documentation:

    https://documentation.alphasoftware....20Function.xml

    Hope this helps.
    Jay
    Jay Talbott
    Lexington, KY


  4. #4
    "Certified" Alphaholic richard2007's Avatar
    Real Name
    Richard Harris
    Join Date
    Sep 2007
    Location
    Ashford, Kent, UK
    Posts
    1,091

    Default Re: Get sum of child table in grid row

    Quote Originally Posted by Jay Talbott View Post
    Did you try dbsum()?

    Here is the documentation:

    https://documentation.alphasoftware....20Function.xml

    Hope this helps.
    Jay
    Thanks Jay, I haven't tried this.

Similar Threads

  1. Replies: 0
    Last Post: 02-09-2016, 01:40 PM
  2. Table lookup issue with image reference file being stored in child table of a set. Weird or what?
    By preston2 in forum Alpha Five Version 11 - Desktop Applications
    Replies: 6
    Last Post: 01-08-2016, 10:26 AM
  3. How do I access linked grid Parent Field > Child Field linking values in child grid?
    By TheSmitchell in forum Application Server Version 11 - Web/Browser Applications
    Replies: 5
    Last Post: 10-02-2012, 03:04 PM
  4. Lookup with dynamic filter in child table using field from parent table
    By Fisher in forum Application Server Version 11 - Web/Browser Applications
    Replies: 4
    Last Post: 11-11-2011, 08:06 AM
  5. Updating the main grid with info from the child grid in a tabed grid linker
    By Mwhite in forum Application Server Version 9 - Web/Browser Applications
    Replies: 5
    Last Post: 06-30-2009, 05:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •