Field total on a found set

[rudym88]

Hi all,

I sure this will be a simple solution but I just can't figure-out what how to do it.

I have two tables;

Table A

Client ID

Client Name

Complain

Solution

Table B

Client ID

Invoice No

Invoice Amount

Invoice Amount Total (Summary Field)

I also have a layout that shows field from from Table A and Table B.

I need to show the "Invoice Amount Total" for a given Found Set without sorting on a Header or Sub-summary part but in Browse Mode.

Any help is GREATLY appreciated

Thanks

RudyM

Edited March 28, 2010 by Guest

[bruceR]

Put Invoice Amount Total (Summary Field) on the layout.

[rudym88]

Hey Bruce thanks for the post.

If I place the "Summary Field" on the Body or the Header- It will only show the total for a single record.

If I create a "Sub-summary Part" below and above and it also only shows total for record.

Thanks

Rudy

[bruceR]

That's definitely not true. A summary field shows the data for the found set. That's exactly what it's used for. I suggest you post a copy of your file; or a clone; or a simplified version so that we'll have something to look at.

Regarding:

"I also have a layout that shows field from from Table A and Table B."

This statement needs clarification - what is the table occurrence that this layout is based on?

Edited March 28, 2010 by Guest