Announcement

Collapse
No announcement yet.

Two questions

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Two questions

    Hello,

    1. Is there any inbuilt method to check duplicate entries. The form should prevent duplicate entry

    2. How to refer form fields in macro. For example, to verify content of a form field with a table and notify the result

    Thanks

  • #2
    Originally posted by omonm View Post
    Hello,

    1. Is there any inbuilt method to check duplicate entries. The form should prevent duplicate entry

    2. How to refer form fields in macro. For example, to verify content of a form field with a table and notify the result

    Thanks
    1. If you design your database correct then it will not be possible to enter duplicate values as the database will refuse that (you get an errormessage). Just define your primary key ok.
    2. Verification of fieldinformation can be done in different ways. By reference, which is a matter of defining the field as a look-up and make the field required (will force that a correct value will be selected). Other option is to add code to the onvalidate event. Formfields can be accessed by putting them between {}, i.e. {myformfield}. On error you can display the errormessage.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      For first questions SC has a way for do it.
      Form Settings - Unique key : You define your fields.

      Comment

      Working...
      X