[AccessD] Films and photos...

[Kostas Konstantinidis]

hi all,
Into a simple subform I keep photos of various films
IdFilms (long Integer) e.g. 9999
PhotoType (Short Text) which contains the words Poster or Shooting Photo or
Film Photo
PictureName (Short Text) like 9999_01 to 9999_xx

What I need is:
1. "after PictureName update" to check if it begins with wrong IdFilms,
getting a warning message
2. If it's possible "after update PhotoType" to get automatically the next
PictureName e.g. 9999_02


thank's
/kostas