Displaying Related Data

[kahorui]

Hi,

I've been having some trouble and

wondering if there is any solutions for this.

The file has the following relationships:

1: Supplier Name::Supplier Name Itself

2: Invoice No::Invoice No Itself

3: Line Item::Line Item Itself

The file also include the following data for each:

1: Sales Amount

2: Purchase Amount

I would like to output the data as following:

Supplier Name

Invoice No Sales Amount Purchase Amount

(Each line has the sum of each Line Item's sales amount &

purchase amount for one Invoice No.)

Subtotal of Sales Amount & Purchase Amount

(The sum of sales amount & purchase amount for each supplier)

I understand that can be done with Preview & Print.

However, I'm wondering if there is any way to see

the data in Browse mode.

[LiveOak]

Its hard to give you a specific answer as you didn't give "The file" a name and didn't tell us what each record in "The file" represents.

The general answer to your question is if you wish to see summary numbers in browse mode, use relationships and the Sum() functions to create the totals.

-bd