Abstract: A system for creating database partial replicas is provided where the referential integrity of the original database is maintained in the partial replica. Filters are specified to allow a user to select, using boolean logic, which rows of the original database are to be propagated to the partial replica. A row containing the primary key corresponding to a foreign key of a row propagated to the partial replica is also propagated to the partial replica. Also, a filter may be specified to include rows that are part of a relationship between multiple record sources. The result is a partial replica database containing only those records desired by the user but also all the records necessary to maintain the referential integrity of the original database.