User Profile

Collapse

Profile Sidebar

Collapse
mreed72
mreed72
Last Activity: Aug 27 '12, 06:55 PM
Joined: Mar 9 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mreed72
    replied to Saving updates to a datatable to database
    in Visual Basic .NET
    Create a connection to the second database, and then have the tablemanager update the table for the second database instead of the first:

    instead of:
    Code:
    Me.TableAdapterManager.UpdateAll(Me.Database1DataSet)
    Use:

    Code:
    Me.TableAdapterManager.UpdateAll(me.Databse2Dataset)
    See more | Go to post

      Leave a comment:

    • mreed72
      started a topic related data needs 'moved' to different relationship
      in Access

      related data needs 'moved' to different relationship

      I have a problem and can't get clear enough to figure it out.

      2 tables in my database are related to each other.

      table1 = contacts
      table2 = Jobs

      both are a 1to1 relation, using the standard ID fields to relate to.

      now, each contact holds 1 specific job. Each contact has information associated with it. and it's related to the appropriate job (table2)

      but 1 of the contacts...
      See more | Go to post
      No activity results to display
      Show More
      Working...