+ Reply to Thread
Results 1 to 4 of 4

ACCESS FORM: how to relate a form to 2 tables

  1. #1
    Registered User
    Join Date
    03-17-2013
    Location
    NYS
    MS-Off Ver
    Excel 2007
    Posts
    11

    ACCESS FORM: how to relate a form to 2 tables

    Hi everyone:

    i am trying to create a form which should be by definition a invoice form but hen i enter the costumer ID it should automatically fill the costumers info from the costumers table the same to products.

    how can i do that ?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: ACCESS FORM: how to relate a form to 2 tables

    Create two forms. Make one a subform of the other. Create a parent-Child relationship between the two forms.

    On this link, click on the section for Subforms http://www.datapigtechnologies.com/AccessMain.htm
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    03-17-2013
    Location
    NYS
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: ACCESS FORM: how to relate a form to 2 tables

    I tried to enter the sub-form but it didn't gave me results well,

    let me explain once again....

    i have an Invoice Form and i want to be able to just put in the costumers ID and it should automatically fill the costumers details. but when i enter the sub-form it didn't let me enter anything to the costumer ID, i know i can just move the records one by one but that isn't what i want it to be. so my question is if there is (which i believe it is) a way to make the costumer id the search key which should automatic look for the record and put in the name and details in their place ?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: ACCESS FORM: how to relate a form to 2 tables

    Here is a link on autofilling:

    http://www.baldyweb.com/Autofill.htm

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1