Foreign Key errors

Results 1 to 2 of 2

Thread: Foreign Key errors

  1. #1
    Join Date
    Dec 1969

    Default Foreign Key errors

    here&#039;s the problem I&#039;m using an sql database via msaccess. There are three tables member, applicant and postcode. there is a constraint whereby the postcode and locality in the member table must correspond to those in the postcode table. i have one asp page that lists the applicants from an applicant table, the next page dispays the applicant information with extra fields that are required by the member table. the next page displays all the information from the form then another page that inserts the information into the member talbe.<BR><BR>I keep getting a foreign key error even though the postcode and locality do match. Can anyone give some input to this problem??

  2. #2
    Join Date
    Dec 1969

    Default I guess it is an insert

    sql which is giving the error.<BR><BR>You should show the relevant portion(including the sql) of the code and also post the exact error.

Posting Permissions

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