Jump to content

cpcbsa

Members
  • Content Count

    6
  • Joined

  • Last visited

Posts posted by cpcbsa

  1. Hi, I am trying to build a report from a view which has record information/details/units in one table (with all the information) and a transactions table with incoming money.... if I have the main table with the info and i create fields for the totals per unit, I am able to create pretty nice reports that total etc... if I try to create that report with a view (join of the two table) things do not work. Is there a way to have a transaction table with a bunch of transactions that auto updates a total field in the associated record on the information table?

     

    I tried also building reports with SQL statements but caspio does not seem to work with the DISTINCT statement in reports properly...

    Thanks,

×
×
  • Create New...