Results 1 to 2 of 2
  1. #1
    Stephenson is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Location
    North West
    Posts
    110

    Form to accept/display entries for multiple records for certain fields

    Hello all,



    I'm attempting to put together a form to enter records for my vendors. One vendor can have multiple records for contacts.

    I've built my first form, frmVendor. This form is connected to tblVendor that has the following fields.

    VendorID
    VendorName
    ContactID
    PhoneNumber
    Email
    FaxNumber
    StreetNumber
    StreetNameID
    CityID
    StateID
    ZipID

    ContactID is the foreign key in a one to many relationship with ContactID in tblContact. tblContact has the following fields

    FirstName
    LastName
    PhoneNumber
    AltNumber
    Email

    I would like to build a form that I can easily enter records for the fields for tblVendor as well as enter multiple records for tblContact. I just can't wrap my head around how to accomplish this. I assume I will need to incorporate the use of subforms, but I do not have much experience using them.

    If anyone has some good ideas for me I would be very happy to hear them.

    Thank you for taking a look,

    John

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    The first step is usually to get your business rules written down; then create tables and relationships to support those rules; test the data model with some sample data; then work on user interface and forms.

    See this recent thread for more info
    Good luck.

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

Similar Threads

  1. Replies: 4
    Last Post: 11-02-2015, 02:23 PM
  2. Replies: 2
    Last Post: 11-18-2013, 10:30 AM
  3. Replies: 3
    Last Post: 02-22-2013, 11:34 PM
  4. Not able to make multiple entries (records) in the table
    By ramindya in forum Database Design
    Replies: 3
    Last Post: 03-04-2012, 12:53 PM
  5. Replies: 11
    Last Post: 10-04-2011, 02:29 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