Jump to content

Getting field Info from previous record


This topic is 7211 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

This topic is 7211 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.