Results 1 to 2 of 2
  1. #1
    mar7632 is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Feb 2019
    Location
    Spain - Madrid
    Posts
    72

    Relationship 1to1 is not recognized in a form

    Hello everyone,



    I have two tables which have a relationship one to one. The way I introduce data is from a form in which I click on a button and it transfers all the information to the table called "aa_DatosRecibidos". Everything work as intended.

    But when I created a new form with both tables with this mechanism (with this button which is basically a DoCmd.TransferSpreadSheet), the second table called "aa_DatosProyecto" does not update correctly in the form.

    I tried to do some tests. If I create a new form with both tables with their respectively field and introduce all the data manually it works (the "id_item" updates on both).

    It seems like the "id_item" from "aa_DatosProyecto" does not recognize the relationship with the table 1 when both tables are in a form with this command button.

    Could you help to solve this problem?

    Thank you in advance,

    Regards.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why have 2 tables?

    I do have a db with 1 to 1 tables. There is 1 master table and about 100 related tables, each 1 to 1 with the master. For only 2 tables I would probably not split them.

    I do not use a form that includes multiple tables for record creation. Form is bound to master and code creates records in specified related tables. Then other form(s) are later opened to input data into related tables.

    Why would this involve TransferSpreadSheet?

    What information is 'transferred'?

    Provide code for analysis. Or the database.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. OLE Server Isn't Recognized
    By Luvflt in forum Access
    Replies: 9
    Last Post: 07-08-2015, 08:00 AM
  2. Why blank fields are not recognized.
    By Luvflt in forum SQL Server
    Replies: 16
    Last Post: 04-08-2015, 11:54 AM
  3. Field Not Recognized
    By Rustin788 in forum Reports
    Replies: 1
    Last Post: 08-25-2014, 10:34 AM
  4. Loop or Array not recognized
    By dvgef2 in forum Forms
    Replies: 6
    Last Post: 05-31-2013, 08:37 AM
  5. Replies: 6
    Last Post: 04-19-2012, 06:48 AM

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