Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    galion oh
    Posts
    4

    Red face Unanswered: Key value in use

    On a form with 2 child files linked to the master file [ the master file has no data changed ], the error "this key value is already in use" appears when moving off the the current child files to select the next master record. Both child files have data entered for each master file record. Where most likely does this occur and what can cause it? What can prevent this situtaion? This is paradox 8 running on an NT server.
    Any help will be appreciated. thanks,

  2. #2
    Join Date
    Aug 2003
    Location
    Bologna - Italy
    Posts
    209
    The child tables use keys?

    Do they have a composite key (2 or more fields) or a single key?

    Can you describe in detail the relationship between the three tables?
    The only failure is not trying to do it.

Posting Permissions

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