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.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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