Professional Web Applications Themes

Access weird behaviour? - Microsoft Access

The scenario: I got a few tables in an access file. Their relationship were all indeterminant. Then I found out that there are no primary key on all the tables. I add a primary key to table A and index the rest with no duplicates because they should have a one-to-one relationships. There are three forms: A, B and C. C is a subform of B, and B is a subform of A. In Form A, there is a search button. The Problem: While the tables' relationship are indeterminant, I can use the search button to search a record and ...

  1. #1

    Default Access weird behaviour?


    The scenario:
    I got a few tables in an access file. Their relationship
    were all indeterminant. Then I found out that there are no
    primary key on all the tables. I add a primary key to
    table A and index the rest with no duplicates because they
    should have a one-to-one relationships.

    There are three forms: A, B and C. C is a subform of B,
    and B is a subform of A. In Form A, there is a search
    button.

    The Problem:
    While the tables' relationship are indeterminant, I can
    use the search button to search a record and load the data
    to B and C.

    After I change the tables to a one-to-one relationship,
    the data won't load to B and C.

    Does anyone know how to fix this problem? Form B is
    generated from Table A and Form C is generated from Table
    B. Form A is only use for searching and loading data into
    Form B and C.
    speederpro Guest

  2. #2

    Default Re: Access weird behaviour?

    On Tue, 15 Jul 2003 09:44:27 -0700, "speederpro"
    <speederprohotmail.com> wrote:
    >
    >The scenario:
    >I got a few tables in an access file. Their relationship
    >were all indeterminant. Then I found out that there are no
    >primary key on all the tables. I add a primary key to
    >table A and index the rest with no duplicates because they
    >should have a one-to-one relationships.
    One to one relationships are QUITE UNCOMMON. Unless you're using
    Subclassing (and know that you're using it, and why) I suspect you
    don't actually want one to one.
    >There are three forms: A, B and C. C is a subform of B,
    >and B is a subform of A. In Form A, there is a search
    >button.
    >
    >The Problem:
    >While the tables' relationship are indeterminant, I can
    >use the search button to search a record and load the data
    >to B and C.
    >
    >After I change the tables to a one-to-one relationship,
    >the data won't load to B and C.
    >
    >Does anyone know how to fix this problem? Form B is
    >generated from Table A and Form C is generated from Table
    >B. Form A is only use for searching and loading data into
    >Form B and C.
    What are the Recordsources for the three forms? Are you attempting to
    store data redundantly in the three tables? What are some typical
    fields in these tables? I think the basic problem is in your table
    structure, not the forms!

    John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
    [url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]
    John Vinson Guest

Similar Threads

  1. Cocoa in Carbon - weird behaviour
    By Eric VERGNAUD in forum Mac Programming
    Replies: 0
    Last Post: October 1st, 12:22 AM
  2. substr() as subroutine argument -> weird behaviour
    By nobull@mail.com in forum PERL Miscellaneous
    Replies: 0
    Last Post: August 14th, 06:19 PM
  3. [PHP-DEV] weird behaviour with ext/tokenizer and heredoc
    By Patrick Preuster in forum PHP Development
    Replies: 0
    Last Post: August 8th, 12:35 PM
  4. Weird Variable Behaviour
    By Jerz in forum PHP Development
    Replies: 0
    Last Post: July 31st, 09:46 AM
  5. Gnome 2 fonts : weird behaviour in SID
    By Dominique Deleris in forum Debian
    Replies: 0
    Last Post: July 1st, 03:00 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139