Do you have access to a barcode scanner? Most periodicals are printed with a barcode these days. With such a scanner, the librarian can simply bring up a layout for the purpose and then scan each periodical with the scanner to log its receipt.
I recommend that you have two tables linked in this relationshihp:
Periodicals::__pkPeriodicalID = ReceptionLog::_fkPeriodicalID
Log the title, frequency etc in fields in Periodicals.
ReceptionLog need only have two fields though more can be added if necessary:
_fkPeriodicalID and DateReceived
DateReceived can auto-enter the current date when a new record is created in ReceptionLog.
Either scanning the barcode like I described or You can use this method:
Pull up an alpabetical list of periodical titles from the Periodicals table with a button next to each title. Clicking a button next to the periodical table can perform this script.
Set variable [$PID ; value: Periodicals::__pkPeriodicalID ]
Go to Layout [ReceptionLog]
Set field [ReceptionLog::_fkPeriodicalId ; $PD]
Go to Layout [original layout]
On a different layout based on Periodicals, you can use a portal to ReceptionLog to list all the dates for which that Periodical was received.
Thank you for your reply Phil. I'll take your suggestion to the people involved in the project.