Results 1 to 2 of 2
  1. #1
    trumpetman is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    11

    Relationship: 2 relationship from one form to one relationship in another form.

    I am working in 2010.

    The Forms are set out like table with columns.



    In one of the form the columns is a drop down box from the contact list in another form, which is set out the same. I think the relationship is to the ID in contact list. I have now added a new field, column, and I would like to have a drop down box with the names in the contact list. But when I try this it says that that will change the other relationship.

    In a nutshell.
    I want one form to have two columns to be able to use the same field in another form. Is this possible?

    Thanks

  2. #2
    llkhoutx is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Form relationships, either filters or master/child links, are hard coded or specified, not implied. Adding another combo box will not affect the your relationship.

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

Similar Threads

  1. form/subform relationship
    By vientito in forum Programming
    Replies: 7
    Last Post: 10-27-2014, 06:53 PM
  2. Relationship / Form Advice
    By StevenCV in forum Access
    Replies: 1
    Last Post: 02-06-2014, 06:54 AM
  3. Relationship issue on my form
    By BigMac4 in forum Access
    Replies: 4
    Last Post: 08-30-2012, 07:27 AM
  4. Form/Subform relationship
    By justhininabouti in forum Forms
    Replies: 2
    Last Post: 11-28-2011, 09:07 PM
  5. Replies: 0
    Last Post: 02-16-2006, 09:11 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