Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012
    Posts
    5

    Unanswered: Relationships Woes

    I have a databse with tblContacts that has two locality fields LocalityResidID and LocalityPostalID both are long integers, they appear to be exactly the same. I have a tblLocalityStatePostCode with LocalityID as the PK and is a long integer and Locality, State and PostCode are text fields. The purpose of this table is to populate text fields in the tblContacts by way of a list box on the frmContacts.

    The problem is I can’t create a one to many relationship on one of the localityID fields, one works the other doesn’t. I have checked all the field properties, they look the same and if I change the order of trying to apply the relationship it still doesn’t work. If I show and second table in the relationship window still no good.

    I can get it to work on a test database but not on the main one I am working on. Can anyone shed some light on the problem?

    Thanks for reading my post.
    Di

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if its working OK on you test db and not your live db then do a detailed comaprison between the two
    don't forget if you are retrospectively applying a foreign key relationship then you need to check that the data complies with the proposed key.

    mind you your design seems odd to me. perhaps you are obfuscarting the design using LocalityResidID and LocalityPostalID. if its a postcode call it a postcode and stop (*^(* about.
    you have a table called
    tblLocalityStatePostCode with LocalityID as the PK and is a long integer and Locality
    leaving aside the naming this seems daft. isn't the postcode by itself sufficiently unique
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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