In an after.input I would like to check if the record in the main table is a new record. Does anyone know the syntax. Also what would I check to see if the record has been modified.

You can also try to use the pre-defined variable "update.status".

Usage:

if update.status = ADD.SET then

you can also use:

0 no update
ADD.SET during add
MODIFY.SET during modify
MARK.DELETE during delete