Okay Two related databases. Database1 (composed of portals to show DB2 infor and other DBs) has button script to go to Database2 and create new record. At this point the user is prompted to fill in all fields. I cannot have fields empty since it is important information.

Problem is, sometimes users go to DB2 and generates new recordby accident. Can I make a script for a button to allow them to go back to DB1 and either deleting or overriding the Validation, WITHOUT giving the user ability to delete records NOR change the field validation?

Not in version 5, as far as I am aware. You can, however, show a message before creating a new record, prompting the user to confirm that they do indeed want to create a new one.

Good Idea, thank you.

However, now when the message pops, even if I hit Cancel the script executes and DB2 opens with new record, and it is back to square one above .

What do I have to do for when the user hits cancel revert back to DB1?

Assuming that Cancel is the second option, after the Show Message step, add

If [status(CurrentMessageChoice) = 2]

Halt Script

End If

WOOHOO!

Thank you.