Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    42

    Unanswered: validate list of value

    hi,
    i have this problem and i don't know what to write to retrive the right data.
    i have a view that contains three fileds code,desc,category.
    and another table that has the just the code in it appears on the screen as list of values,containing the desc of this code.
    i need to validate if i chose one of the codes in the table and exists in the view under the same category to be able to change the list else it should give me a message the code in not inder the same category.

    to make it more clear:
    view
    code desc catogory
    aa first mm
    ai second mm
    bc third lm

    table
    code
    aa
    ai
    bc

    if the list of value was on aa i can do update and change it to ai but i can't change it to bc because it is not in the same category.

    thanks,

  2. #2
    Join Date
    Oct 2003
    Posts
    87
    edit: oops, wrong thread . . .
    Oracle - DB2 - MS Access -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •