Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Linked Databases (2) not updating

Linked Databases (2) not updating

Linked Databases (2) not updating

I have 2 databases.
The source database contains Customer Names (Customers)
The destination database contains Customer Information (CustInfo)
The tables used to link the two databases are: tblCustomer from Customers with the field CustomerID as primary key; and tblCInfo from the CustInfo
tblCinfo has a field: CustomerID as a number field.
Relationship between the two is: Customer.CustomerID to CustInfo.CustomerID (one to one)
In Database CustInfo, the table: ->tblCustomerID was created when linking the two databases.

When a new name is entered in Customers, the CustInfo is not being updated.

What am I missing?

RE: Linked Databases (2) not updating


When a new name is entered in Customers, the CustInfo is not being updated
Not sure what you expect to happen, that is not happening.
You have two related tables. If you enter a new record in customers, that is not going to automatically create a foriegn key in custinfo if that is what you are saying. You can create a query with a left outer join from customers to customerinfo so that you can create a new custinfo for a new customer.

RE: Linked Databases (2) not updating

Thank you! That makes sense, as usual I was making it harder than it was.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close