AnsweredAssumed Answered

Problem in TimeStart and TimeEnd

Question asked by xtremu on Dec 1, 2010
Latest reply on Dec 5, 2010 by xtremu

Title

Problem in TimeStart and TimeEnd

Post

I have two tables, Student Table and AccessLog table

Student Table

AccessLog table

Student Number

Number

StudentID

Number

LastName

Text

TimeStart

Time

FirstName

Text

TimeEnd

Time

StudentID

Number (AutoSerial)

 

 

Barcode

Number

 

 

Relationship is Student:StudentID and AcccessLog:StudentID.

I made a portal in the Student Table for TimeStart and TimeEnd fields. I want to view the Time of the system in TimeStart fields for his/her first entry using his/her student number and the second entry will log the time in TimeEnd field of the portal etc.loop it up to the last entry. I have TimeIn log for now and my problem is the TimeEnd log doesn’t show in the TimeEnd field. Anybody help. I’m using FileMaker Pro 11 Advanced. I am developing a simple Time Entry Monitoring of the students. Below is the script:

Thanks in advanced and more power FM.

xtremu

access_log_script.jpg

Outcomes