Enforcing referencial integrity during file import
I have a database where I have two join tables and want to enforce referential integrity during file import. There are NO client users. The tables are used simply to take existing data, manipulate it via calculations and reexport for consolidation in excel. I would like to be able to enforce referential integrity. For example, when I import a child table that allows creation of records in a related table, import doesn't seem to do the trick. Any advice?