p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Access 97 - Appending one table from another


Message #1 by "Claudine Martinez" <claudine_nm@y...> on Tue, 19 Jun 2001 16:22:46
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?
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Tue, 19 Jun 2001 08:28:44 -0700
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?




  Return to Index