Linked Databases (2) not updating 1

[monkeysee]

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?

 

[MajP]

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.

 

[monkeysee]

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