I have cash file with fields:

Date

Input

Output

Rest

For any date i may have few records.

I want for every record in Rest field see the rest of money for current record.Can i do it? I want that Rest field be calculation field for dinamic work. All this i want to do in v6.

Thanks!

Do you mean you want to see the rest of the money for the current date? If so, create a self-relationship based on Date. Then make Rest a calculation of Sum(rel::Input) - Sum(rel::Output) - Input + Output.

If I'm misunderstanding, please elaborate on your question.

Excuse, I have not so correctly written.

For example:

Date____________Input__________Output_______________Rest

12.01.04_________50______________40__________________10

12.01.04_________30______________20__________________20

13.01.04_________60______________70__________________10

13.01.04_________30______________15__________________25

15.01.04_________40______________20__________________45

20.01.04_________15______________20__________________40

And so on. Number of records may be 100000.

In example you can see that for one date i can have few records and the rest for every record is different.And i must have an opportunity to add and edit records in any place of a file

And i must have an opportunity to add and edit records in any place of a file

This isn't allowed in Luca de Paciola's invention the double sided book keeping from 1489, a quick call to you accoundant will confirm that still is considered cooking the books even if you're Kenny Lay form Enron!!!

But the way to handle this by implementing this: http://www.filemakerpros.com/LULAST.zip ...But say you wish to simulate/budgetize a cashflow by removing or alter the ways the charges comes should the relookups work on the found (sets) of the singled out record - a bit tricky but works on a newly sorted flow.

That being said, must you consider which is the right tool to utilize a spreadsheet or a database? I would say database for book keeping and SS for budgets....

--sd