AboutJamey Key Expertise NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.
Experience Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.
Expert: Jamey Key Date: 4/2/2008 Subject: Get Record Function
Question I've being try to use this function to calculate the next day on my database
(the database obviously has a date field-and each record has a different
date):
GetNthRecord(Date;Get(RecordNumber)+ 1)
My problem with this function is that its going to the next record (based on, I
think, the record ID number and not the actual date). In the cases that I
created new records in the same order as their date, it works properly, but
records that are created out of order pull up the wrong information.
I've got all the records sorted by date, so is there any way to modify this
function so that it calculates the next record based on the sort order? Or is
there some other way to calculate the next day? I have a few other fields that
I'm using this same function to get me the field contents of a certain field in
the next day's record (so I'm hoping I can use the same calculation for all of
this).
I'm new to filemaker so any help I can get is greatly appreciated
Answer Hello Elizabeth;
Let me make sure Im clear. You want to find the date on the next record? So if you are in record 1, you want to find the date of record 2, while looking at record 1? Correct? Email me directly and we will get it worked out.
