Portal - Auto enter from last field

[Sipa]

:) HI There,

I been working on one fo the project were master file is creating portal as follows.

fields =

1)Day

2)Date

3)Driving Hour (can't be <0 & >12hour)

4)Working Hour (Can't be <0 & >24hour)

5)Start Kilometer

6)End Kilometer

7)Total Drive Hour

8)Total Work Hour

9)Start Kilometer (First day open kilometer)

10) End Kilometer (Last day close kilometer)

11) Kilometer travelled

: Solution is like:

User enters the detail of how many kilometer traveld by driver in day one. and then day two so the End kilometer on the day one will be autoenter as a start kilometer for day two.

: Question:

1) How do i restrict user to add time in given restricted format + between the time lenth?

2) How do i get End kilometer pest automatic in Start kilometer when user start enterind second line.

3) How should i show the start kilometer and end kilometer of the end of the trip in the respactive field?

Thanks: i have gone through most of the problems and answer to thous preety impresd that i got right place to post my question.

Sipa

Edited January 19, 2007 by Guest

[Raybaudi]

2) How do i get End kilometer pest automatic in Start kilometer when user start enterind second line.

Suppose that we have two tables, Drivers and Travell related by driverID.

StartKilometer is a field of table Travell with option of auto-enter a calc:

Drivers::Last Day Close

where "Last Day Close" is a calculated field of Drivers and calc:

Max ( Travell::End Kilometer )

[Sipa]

Hi Ray,

Thanks for taking time to answer to my post! As all this field is user enterable. That means at the day one user will fill the information of start kilometer and when he/she enter's second day information the first kilometer will be automatically start kilometer for the second day.

For more convenience I have pasted images for foreground and background to understand my project.

[Sipa]

Question:

1) How do i restrict user to add time in given restricted format + between the time lenth?

[color:red](Manage to fix the problem)

2) How do i get End kilometer pest automatic in Start kilometer when user start enterind second line.[color:blue](Only need to fix this one)

3) How should i show the start kilometer and end kilometer of the end of the trip in the respactive field?

[color:red](Manage to fix this too)

any one here to take a left brain challange? I think i must repost this topic in Portal trade!

Sipa

Edited January 30, 2007 by Guest