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.