Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Ventura, California, USA
    Thanked 0 Times in 0 Posts

    Updating Tables (2000)

    Hey Folks,

    I am writing a large scale multi table Access program. I have written many small ones but nothing of this size. My problem is this. I have 15 tables all set -up with relationships based off of an accounting unit to track properties and loans. The problem I have is the PK key one table does not update the FK in the next so I cannot write my forms to update the other table. It is a 1 to many relationship and when I click on the the PK table it shows the "+" sign and the FK table. How do I get the first table to pass the data to the second table?? I have tried queries and basically at a loss.

    Any help would be appreciated.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Updating Tables (2000)

    Don't use tables or queries for data entry, use forms and subforms instead.

    You should create a main form based on the "central" table on the "one" side of the relationships, with subforms for each of the tables on the "many" side of the relationships. Join the subforms to the main form by the PK of the main table; that way, this PK will be entered in the subforms automatically when you add a record.

    If you have many subforms, put them on pages of a tab control. The tab control is a very convenient way to organize them into an uncluttered layout.

Posting Permissions

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