I have a db with many layouts and would like to be able to go to a specific
layout based on the text that is entered in a field. I don't understand
what to calculate to get the 'Layout Name by calculation' or Layout Number
by calculation' to work. The text in the field that will be queried will
either be 'portrait' or 'school'. Any help will be appreciated.

Kenny

Then your calculation would be either "Portrait" or "School". Or if
there is a field that holds the desired layout name, you can use just
that field's name as your calculation. Or for only two layouts, you
could just use an If/Else statement in your script to go to the desired
layout.

KennyS wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

That's the part I don't understand.... WHAT AM I CALCULATING? I tried (If
jobtype="portrait", portraitlayout, schoollayout) but I got 'table not
found' error for 'portrait' Can you give me an example of a calculation
that I can try?

Thanks for your reply.
KS


"Howard Schlossberg" <howard (AT) antispahm (DOT) fmprosolutions.com> wrote

If you have a layout named 'portrait', and a layout named 'school', and
a field called 'jobtype' which equals 'portrait' or 'school'... then you
"calculation" is JUST:

jobtype

(which evaluates to either 'portrait' or 'school')

if the layouts are named 'por' and 'sch' and jobtype is defined as above
then the calc might be:

left(jobtype,3)

if the layouts are inexplicably named 'hobo' and 'lunchmeat' then the
calc might be:

if(jobtype="portrait","hobo","lunchmeat")


hth

-regards,
Dave

In article <RIOdndMmNaocbNbeRVn-tA (AT) adelphia (DOT) com>, ks4078 (AT) hotmail (DOT) com
says...

Thanks! I got it. I think I left out the second & third set of quotes in
my calc before.
KS
"42" <nospam (AT) nospam (DOT) com> wrote