Results 1 to 5 of 5
  1. #1
    mjhnps is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2011
    Posts
    3

    Populate Related Fields in Multiple Tables..?


    I need help creating a form that will auto-populate data for two linking fields in multiple tables (ASMIS_ID and LINK_ID). How can I get my form to auto-populate data in the linking fields..?

  2. #2
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Welcome to the forum

    We'll need to get a better understanding of your table structure (table names, key fields, relationships etc.). Can you provide that? I generally show tables as follows, but you could also paste your relationship diagram if that is easier:

    tblOrders
    -pkOrderID primary key, autonumber
    -dteOrder
    -fkCustomerID foreign key to tblCustomers

    tblOrderDetails
    -pkOrderDetailsID primary key, autonumber
    -fkOrderID foreign key to tblOrders
    -fkItemID foreign key to tblItems

  3. #3
    mjhnps is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2011
    Posts
    3
    Quote Originally Posted by jzwp11 View Post
    Welcome to the forum

    We'll need to get a better understanding of your table structure (table names, key fields, relationships etc.). Can you provide that? I generally show tables as follows, but you could also paste your relationship diagram if that is easier:

    Hi, thanks for your quick reply...

    Attached, is a database, that includes some forms I've created to make data population less cumbersome--although, I believe there has to be a better design. I can't adjust the tables, because they are a national standard, and cannot be altered

    In essence, what I'm trying to do is autopopulate identical fields in multiple tables. In other words I could enter the values for ASMIS ID# & SUBSITE and the form would then auto-populate those entries for all tables containing those identical fields. The forms i've provided indicate the required fields for all related tables. Sorry, if they look unwieldy.

    The workflow I'm looking for is...

    ASMIS <table> will be the primary/master form, while SUBSITE <table> would serve as the central hub to all tables with ASMIS ID # & SUBSITE as related fields. There can be multiple SUBSITE fields to one ASMIS ID#, so I'd like to have a form that will automatically add the next sequence (000, 001, 002, etc) to the SUBSITE field upon triggering an "Add New Subsite" button. Those entries will then auto-populate the identical ASMIS ID# & SUBSITE fields in all related tables.

    Any help would be greatly appreciated... Plus, I'm sure you fantastically, challenge-oriented programmers may want to take a stab at it.

    Cheers,
    Mike

  4. #4
    mjhnps is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2011
    Posts
    3
    Please click on the attached image to see the relationships of this database....

    Thanks for viewing,
    mike

  5. #5
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    I can't adjust the tables, because they are a national standard, and cannot be altered
    Without being able to normalize the table structure, you are going to have all kinds of problems in whatever you do with this database. I'm usually up for a good challenge, but with my hands being tied by not being able to alter the table structure, I'll have to pass. My apologies.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-11-2010, 11:00 AM
  2. Not able to make Form from related Tables
    By a1y1a1y1 in forum Forms
    Replies: 5
    Last Post: 01-02-2010, 12:33 PM
  3. Table related to multiple tables by single ID
    By MrTumnus in forum Access
    Replies: 1
    Last Post: 11-17-2009, 02:05 PM
  4. 3 Related Dependent Tables
    By jbarrum in forum Access
    Replies: 0
    Last Post: 11-17-2009, 11:27 AM
  5. Split a table into related tables
    By triley01 in forum Database Design
    Replies: 1
    Last Post: 03-12-2009, 02:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums