Getting field Info from previous record

[Big Jim]

Hello all you Filemaker Guru's, (Something I am definetly ... NOT!)

Ok, I am hoping someone can shed a little light into my brain here. I am making this database, what I want to do is get the value in the "new Balance" field to automatically be entered into the "balance" field when a new record is created.

I have been racking my small brain with this all morning

HELP HELP

Thanks In advance.

Jim

[-Queue-]

If you have a self-relationship based on client/customer/whatever ID, which is sorted by a date field (or date and time fields) descending, then you can use an auto-enter of relationship::balance.

[Big Jim]

Hmmmm, Well maybe I am just super confused and should put Filemaker back in the box! (NO, Not Going To Happen.)

Ok, Here is what I have:

(Basically, this is a file that would be alot like a check register)

There are multiple fields but the two I am concerned with are the "Balance" and "New Balnace" Fields. What I would like to see happen is that whenever the user goes to add a new entry value in the "New Balance" from the last record, automatically populates the "Balance" field in the new record.

I did make a self-relationship, but it does not seem to work.

Again Someone:

HELP HELP

:-)

Losing My Mind, One Day At A Time

Jim

[Lee Smith]

Hi Jim,

Here are a couple of Check Books that might be helpful to you:

ClickCheck By: Bob Cusick URL:

http://www.fmfiles.com/enduserbus4.html

Checkbook By: Dwayne Wright URL:

http://www.fmfiles.com/enduserbus4.html

HTH

Lee