Alpha Video Training
Results 1 to 3 of 3

Thread: lost child records-complicated problem?

  1. #1
    Andy Neufell
    Guest

    Default lost child records-complicated problem?

    I have a newly created four level set that is used for setting up jobs for our shop. When a qty field is changed in the second level, we lose the record that is linked to that in the third level. When I look at the third level exclusivly all of the fields are blank and a "find" will bring me to that record but the fields will be blank. When attempting to Enter this record again to replace the "missing" one, I get a message stating that the field must be unique, so the data is still there somewhere.

  2. #2
    Thomas Henkel
    Guest

    Default RE: lost child records-complicated problem?

    Is the Quantity one of your linking fields?? If so, when you modify it, then the link will go to an entirely different record. Try to keep your linking expressions as simple as possible and you should be OK. If you can, please post the set structure or e-mail it to me. I will try to see where it went bad.

    Tom

  3. #3
    Andy Neufell
    Guest

    Default RE: lost child records-complicated problem?

    fixed:

    There was a one to many link that should have been a one to one link. I don't know if this was the reason for the problem, but I do know that it wasn't the correct way to link two of the databases and correcting it removed the problem.

Similar Threads

  1. Complicated Lookup Problem
    By Charles Hoens in forum Alpha Five Version 6
    Replies: 2
    Last Post: 08-07-2005, 06:36 PM
  2. Lost in Child Table Land...
    By Dave Keller in forum Alpha Five Version 6
    Replies: 3
    Last Post: 02-08-2005, 06:22 PM
  3. lost records
    By Marie Eastman in forum Alpha Five Versions 2 and 3
    Replies: 3
    Last Post: 11-19-2004, 01:12 PM
  4. Lost Records Sometimes
    By Bruce MacPherson in forum Alpha Five Version 4
    Replies: 5
    Last Post: 03-29-2001, 05:23 PM
  5. Problem marking child records
    By richardurban in forum Alpha Five Version 4
    Replies: 2
    Last Post: 02-12-2001, 05:15 PM

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
  •