dbTalk Databases Forums  

sequential number

comp.databases.filemaker comp.databases.filemaker


Discuss sequential number in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
shai Ben Mordechai \(Rosenblum\)
 
Posts: n/a

Default sequential number - 04-13-2007 , 04:39 AM






FM 8.5 - OS Windows XP

I'm working in a project that request to assign a sequential number to a
program (Day...) for each day in a group program day. The result should be a
portal like this.

day 1 11/3/2007 10:35 Arriving
1/3/2007 12:00 Check in at Hotel
1/3/2007 13:00 Lunch
1/3/2007 15:00 free evening
day 2 2/3/2007 08:00 breakfast
2/3/2007 09:00 First meeting
2/3/2007 11:00 Tour

How to calculate the field "Day 1, Day 2 and so on ?

TIA
Shai



Reply With Quote
  #2  
Old   
Hans
 
Posts: n/a

Default Re: sequential number - 04-13-2007 , 06:33 AM






shai Ben Mordechai (Rosenblum) <gla (AT) actcom (DOT) co.il> wrote:

Quote:
I'm working in a project that request to assign a sequential number to a
program (Day...) for each day in a group program day. The result should be a
portal like this.

day 1 11/3/2007 10:35 Arriving
1/3/2007 12:00 Check in at Hotel
1/3/2007 13:00 Lunch
1/3/2007 15:00 free evening
day 2 2/3/2007 08:00 breakfast
2/3/2007 09:00 First meeting
2/3/2007 11:00 Tour

How to calculate the field "Day 1, Day 2 and so on ?
I assume you are in a program record looking at a portal containing the
related child records. You can calculate the day number from the
program's starting date. In the child table define:
Daynumber = date of this record - Program::Startdate +1


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.