I am looking for a way to select a layout based on a date calculation
when openning a record.

Here's the details - I have a database of stocks that I have sold. When
I open a record, I want it to open with layout A if the date of the last
sale of this stock was 31 days or less and another layout if the the
last sale was over 31 days ago.

Can this be done with FM 7? I am thinking of updating to FM 8.

Rich

Rich Sagall wrote on (10/30/2005):

You would have to script the navigation to the record.

You could control it with either an If-Then routine or the Go To Layout
script step, which includes an option to go to a particular layout based
on the results of a calculation.

Far be it from me to discourage upgrading to the latest and greatest, but
it would be the same in 8 as in 7, except that you could perhaps use a tab
object instead of a different layout.

Matt