Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    strange relationship (2002)

    Hi, i wonder if peeps could take a quick look at this frame for a database.

    I have had to make a one to many relationship from a compound key, which works fine, but has the odd double line realtionship( look in relatioships). Is this ok - as i say, it works.

    Also, when i open the main form the revision field in the subform shows 'Name?' until i do a sort or remove the filter ( i dont know how come there is a filter there).

    When i open the subform on its own then the data is fine .

    thanks
    Attached Files Attached Files
    Thanks,

    pmatz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: strange relationship (2002)

    The relationships are OK - it is possible to create a relationship on more than one field, just as it possible to create an index on more than one field.

    Somehow, Access is confused by the double use of Revision: as the name of a table, and as the name of a field in that table. Rename one of the two, and take care to adjust everything that depends on the name.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange relationship (2002)

    Thanks Hans, thats reassuring [img]/forums/images/smilies/smile.gif[/img]

    I thought it might be Access getting confused, as if I included an ORDER BY in the property of the subform then it was ok.

    I will rename as advised.

    I am not quite sure how I am meant to use Indexing, I tend to index most fields that are involved in queries.
    Thanks,

    pmatz

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: strange relationship (2002)

    Don't go overboard with creating indexes. They are useful if you want to
    - Order a query (or form or report) on a field, and
    - Join tables on a field.
    But creating too many indexes can actually have a negative effect on performance - every time you edit a table, Access has to keep track of the consequences for all indexes. See the "optimize performance" subject in the online help.

Posting Permissions

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