Jump to content

Sum text fields in related table


This topic is 5650 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Ok, I am migrating an biding database from 5.5.

In the old version I have a calc field the references discription fields in the same table and gives me a paragraph that is printed with the dollar amount for that"Area".

In the new version, I have made a join table that holds all the line items making it much more flexable, however, how do you summerize text fields from a related table and show them in a paragraph?

Link to comment
Share on other sites

Does anyone know how this could be accomplished?

I see the new function:

GetNthRecord ( fieldName ; recordNumber )

Perhaps this could be used in some fashion in combination with recursion to arrive at a result?

Link to comment
Share on other sites

This topic is 5650 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.