One.mdb (tblOne)

Two.mdb (tblTwo)

Main.mdb (has a link to tblOne & a link to tblTwo)



From main.mdb I can create a relationship between tblOne & tblTwo; 

however, I cannot enforce referential integrity.  If a record is deleted 

from tblOne & need to delete any related record in tblTwo.



What to do?

Without referential integrity you are going to have to build your own

delete queries using the primary key of the record deleted from the

first table as a parameter in the delete query for the second table. If

you need to work this through step by step let me know.



>From main.mdb I can create a relationship between tblOne & tblTwo;

however, I cannot enforce referential integrity.  If a record is deleted



from tblOne & need to delete any related record in tblTwo.<



Richard Lobel

Accessible Data

richard@a... <mailto:richard@a...> 

Cell:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx