Relating All Records

[bb84604]

I know this is a dumb question.

I have 2 databases (Expenses & Deposits) I want to get my account balance by subtracting the total expense amounts from the total deposits in the Deposits file.

If I create a relationship it seems I have to match a field, however, I don't want to relate only certainb records but all of them to get the total amount of deposits.

How can I get that figure (total deposits) from the other database?

I know, simple question, but I'd really appreciate the help.

[comment]

In version 6 and below, you do this by defining a calculation field constant1 (result is number) = 1. Do this in both files, and relate them using constant1 as the match field.

[bb84604]

I'm actually using Version 8. Does that still work?

[Wim Decorte]

In 8 you specify the "x" as the relational operator instead of the default "=". That saves you the calc.

[comment]

It still works, but it is no longer required. Pick ANY two fields as the match fields, and use the "x" operator instead of "=", when defining the relationship.