Hi,

I'm trying to change some features on a student database solution which was designed by someone that we no longer want to employ (don't ask!).

It was originally a FM6 solution but I've converted it to FM7 whilst still keeping it as 16 related separate files.

What I'd like to do is track whether students have handed in a specific assignment by using a handheld text scanner to input the student's id number into a field in the Assignments table which then copies the student's details into the Completed Assignments table.

At the moment we have 2 portals in the Assignments Tracking layout. One of these shows the students who are registered on that module; clicking on a button next to a student's name will transfer that student's details over to the Completed Assignments table, as shown in the 2nd portal on the page. This solution works fine but I think that scanning in the student IDs would save time.

Currently the button in the "current students" portal performs the following script:

Set Field [ Assignments::TempStudentId_g; Studies::StudentSerialID ] 

Commit Records/Requests 

Go to Field [ CompletedAssignments::Student_Serial ] 

Go to Portal Row [ Select; Last ] 

Set Field [ CompletedAssignments::Student_Serial; Assignments::TempStudentId_g ] 

Commit Records/Requests   

Does anyone have any ideas on how I could get this working?

Set the scanner to produce a tab at the end of the scan. The scan will go in Assignments::TempStudentId_g. Use a plug-in that provides event triggers to run the script. You no longer need the first script step.

Hi,

Thanks for replying. One more thing that I forgot to mention is that each student has a unique 8 digit "student ID" which is used throughout college for identification, however in his wisdom the original database designer has also given each student a 3 digit "Student serial ID" which is how the script identifies the appropriate student. Both ID numbers are stored in the Studies table. As we need to use the longer number I've tried just replacing "student serial ID" with "student ID" in the script, but clicking the button just creates a new record with just the student ID without linking to the relevant student in the Completed Assignments portal.

Thanks