Results 1 to 2 of 2
  1. #1
    HDennen is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2009
    Posts
    1

    Question Field from multiple records to multiple fields in one record

    Hello all,

    I am very stuck.

    I've got a data entry form for events with a nested data entry sub-form for the contents of the vehicle going to the event.
    These are from EventsLog table and VanLog table respectively.

    EVENT MAIN FORM
    EVENTSLOG
    EVENT_NAME
    EVENT_DATE
    VAN1_NAME (yes/no)
    VAN2_NAME (yes/no)
    VAN3_NAME (yes/no)
    VAN4_NAME (yes/no)




    EVENT SUBFORM (tabs for each van, separate record in VANLOG for each van selected in main form)
    VANLOG
    EVENT_NAME (linked to main)
    EVENT_DATE (linked to main)
    VAN1_NAME (yes/no linked to same van in main)
    VAN2_NAME (yes/no linked to same van in main)
    VAN3_NAME (yes/no linked to same van in main)
    VAN4_NAME (yes/no linked to same van in main)
    CONTROLLER1 (foreign key)
    CONTROLLER2 (foreign key)
    CONTROLLER3 (foreign key)
    CONTROLLER4 (foreign key)


    CONTROLLERS
    ID
    S/N
    SUBLOC

    I need the S/N's of all controllers with a subloc = van_name to populate the CONTROLLER1, CONTROLLER2, etc. fields in the VanLog table.

    I hope all that made sense. I'm really not sure how to do this. Any help would be HUGELY appreciated


    -H

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    And if you need 5 Van Names what do you do? You may want to revisit the table structure one more time for normalization.

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

Similar Threads

  1. Search for multiple records
    By Blake in forum Queries
    Replies: 1
    Last Post: 08-23-2013, 03:17 AM
  2. multiple fields in separate records
    By Fredo0709 in forum Database Design
    Replies: 9
    Last Post: 04-09-2010, 12:23 PM
  3. Populating multiple fields
    By jjcaprio in forum Programming
    Replies: 11
    Last Post: 08-16-2009, 01:51 PM
  4. Multiple Fields In One Combo Box.
    By caljohn527 in forum Forms
    Replies: 1
    Last Post: 02-20-2009, 03:07 PM
  5. Linking Multiple records
    By rricci@marcct.org in forum Programming
    Replies: 0
    Last Post: 02-14-2008, 09:18 AM

Tags for this Thread

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