Hello all. I have been trying to find something similar for the past couple of hours and have come up empty handed..

Here is what I am trying to do:

I am working with 1 table 2 layouts.

say the record date is 4/11/2011 - field is "TomoWakeUpCall" (text field) entered as 4:30 am

on 4/12/2011 I would like the feild "WakeUpCall" to auto enter 4:30 am (and viceversa would be excellent) - if I entered it on the 12th instead of the 11th.

I do have a calc field - DayAdd1(date+1) that works but can't put my finger on how to do the same with the WakeUpCall field(s)

I'm basically trying to save myself a few key strokes and page flips.

I do have auto generated s/n for each record but I enter information as I get it so the dates don't always fall in the same order as the s/n's

( i did find some information on GetNthRecord)

Thanks in advance!

I am only guessing here, since the question is not quite clear. If you define a calculation field (result is Date) =

RecordDate + 1

you can then define two self-join relationships showing the records for tomorrow and for yesterday. Certainly, it is not necessary to enter the same information into 2 places.

field is "TomoWakeUpCall" (text field) entered as 4:30 am

Filemaker has a Time type of field, and it is best to use this for time data.