What something like :
field2 = Case(field1 = "breakfast", "2am", field1 = "lunch", "4am",
field1 = "dinner", "6am", "")
or
field2 = Case(field1 = "breakfast", "2am", "")
field3 = Case(field1 = "lunch", "4am", "")
field4 = Case(field1 = "dinner", "6am", "")
Remi-Noel


"Jonathan Peirce" <president (AT) whitehouse (DOT) gov> a écrit dans le message de
news: 070920050001377364%president (AT) whitehouse (DOT) gov...

In article <070920050001377364%president (AT) whitehouse (DOT) gov>, Jonathan
Peirce <president (AT) whitehouse (DOT) gov> wrote:

It really depends on what else you're wanting to do with the fields and
the data.

The simplest method would be: rather than 24+ fields with specific
functions, why not have two sets of 5 fields (for example) that can be
used for anything.
ie.
Event 1 Time 1
Event 2 Time 2
Event 3 Time 3
Event 4 Time 4
Event 5 Time 5

The "Event" fields can use pop-up menus of text labels ("breakfast",
"lunch", etc.) and the second set us another pop-up menus of times.

That way no matter what layout you're looking at the data will match
easily by simply having the appropriate fields next to each other.



The time consuming method would be to have a duplicate set of 24+
fields that are calculations using Case to obtain the correct value.
eg.
2amCalc = Case (Breakfast = "2am", "Breakfast",
Lunch = "2am", "Lunch",
Dinner = "2am", "Dinner",
...,
"")

LunchCalc = Case (2am = "Lunch", "2am",
3am = "Lunch", "3am",
4am = "Lunch", "4am",
...,
"")

Obviously you would need one of these for each time and each label, but
this would be painful to ammend each time you wanted to add a new text
label or time.



The better method would be to store the events and their times in a
second file / table and use relationships and portals to display the
data in the original file / table, but if you're really a "newbie" that
might not be a good option to try until you're more familiar with
FileMaker's relationship abilities since it is more complicated.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

I agree with what's been said so far, it's not the best approach but if
you insist you can do it as follows:
- assume your 24 Time fields are Time1, Time2, Time3...
- the calculation in the "Breakfast" field would say:
Case(
Exact(Time1, "Breakfast"), Time(1, 0, 0),
Exact(Time2, "Breakfast"), Time(2, 0, 0),
Exact(Time3, "Breakfast"), Time(3, 0, 0),
....)