Results 1 to 2 of 2

Thread: How to manage the inlist validation for a fkd in db whose length changed from 1 to 3.

  1. #1
    Junior Member
    Join Date
    Dec 2018
    Posts
    24

    How to manage the inlist validation for a fkd in db whose length changed from 1 to 3.

    Trying to change the sup_type to a value of length 3 lainja wont let me. Got one sup_type change through on record sup_id = 6 but any changes on the other records are being ignored by lianja
    Name:  supplier browse.jpg
Views: 73
Size:  42.3 KB
    Name:  supplier fld setup.jpg
Views: 74
Size:  39.5 KB
    Last edited by josh1705@sbcglobal.net; 2021-05-03 at 20:58.

  2. #2
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,071
    Here's what I would try:

    1) back up your database (Lianja makes this very easy)
    2) remove the choices and validation from the field (and the tooltip: choice will present in a dropdown)
    3) change the field length from 1 to 3
    4) convert all your 1-letter entries to their corresponding 3-letter entries. Make sure that all the entries are one of the 4 permitted 3-letter entries. Scratch your head and figure out to do with any errant entries.
    5) put back the choicelist. Unless you are adding records by code, rather than data entry, the validation entry is not required.

    And that should get you back in business.

    Hank

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us