I have a main database (table) that calls to another database to retrieve 

names.  On my main form, however, I have a combo box which must allow 

users to add names to the main database, while updating the names 

database.  I tried to create a one-to-many relationship between the 

tables, but I got a violation of referential integrity error (all records 

were cleared from the database).  Is there something else I can do?

I'm puzzled by this, b/c I believed it was impossible to enforce RI

constrainst accross .mdb files.



If the problem is just inserting new names into your main table, you should

be able to do this by:



- setting the LimitToList property of your combo to Yes

- in the NotInList event of the combo, put code that

  does a SQL INSERT INTO to add the new name to your

  (I presume linked) table, and set the Response

  variable = acDataErrAdded.



Hope that helps...



Cheers,



-Roy



-----Original Message-----

From: Claudine Martinez [mailto:claudine_nm@y...]

Sent: Tuesday, June 19, 2001 9:23 AM

To: Access

Subject: [access] Access 97 - Appending one table from another





I have a main database (table) that calls to another database to retrieve 

names.  On my main form, however, I have a combo box which must allow 

users to add names to the main database, while updating the names 

database.  I tried to create a one-to-many relationship between the 

tables, but I got a violation of referential integrity error (all records 

were cleared from the database).  Is there something else I can do?