AnsweredAssumed Answered

Calculation Field Problem

Question asked by xtremu on Aug 24, 2011
Latest reply on Aug 31, 2011 by xtremu


Calculation Field Problem


 I have two tables: Student and AccessLog, Relationship is Student::Student Number = AccessLog::Student Number and Student::StudentID = AccessLog::AccessLogID. Allow creation of records in this table via relationship already checked.

In my student table I have Fullname field which is calculation type = First Name & "" & Last Name, In my AccessLog Table I have also a NAME field which is Text type and this table viewed as TABLE VIEW.

During transaction I wanted to have a result in the  Student Number / Name / TimeStart / TimeEnd / Date field respectively in the AccessLog Table. The desired output should like this:

Student Number   -  Name  -       TimeStart  -  TimeEnd  -  Date

201111111                                 4:30:10                         Wed, August 24, 2011  

201122222                                 4:30:30       4:30:45      Wed, August 24, 2011

201133333                                 4:35:00                         Wed, August 24, 2011

201144444                                 5:00:10       5:30:00      Wed, August 24, 2011

This is my problem, the name of student did'nt show in the NAME field of the AccessLog table, the other are ok such as the StudentNumber, TimeStart, TimeEnd and the Date.

I tried different relationships, calculated values, Get functions but have no luck to solve this. Please help to have a name of student in the NAME field of the AccessLog table.


Thanks in Advance.