AnsweredAssumed Answered

I want to Search for a record and if not there Create

Question asked by weedonpaul on Mar 14, 2013
Latest reply on Mar 14, 2013 by weedonpaul

Title

I want to Search for a record and if not there Create

Post

     Does any one have a script that Looks at a table to find a record and if thge record isn't there it creates on.

     I'm trying to Look for a record for a given month and year and if there isn't one it creates one. However I dont want someone (Me) missspelling a month and creating a record when it didn't need to

     I used custom messages to get month and year inputs from user and that worked except when I missspelled March it created a new recored for Mrch.

     I then tried creating a layout that would behave as a custom dialouge box but it didn't unless i pepper the script with pauses

     Now I have a head ache

     Paul

Outcomes