C
cqdigital
I'm building a database that consists of frontend and backend. Some
of the lookup tables need to reside in the frontend database. The
data in the lookup fields that relate to the backend tables will never
change, but a descriptor for items in these fields will. I may need
to update the descriptors periodically, hence the need to keep these
tables in the frontend database so that the new descriptors will be
distributed with frontend updates.
Ideally the lookup fields should be linked to the backend tables with
referential integrity enforced. Because the tables are in 2 different
databases this can't be done.
What options do I have? Given that the lookup fields will always be
under my control and will never change, is enforcing referential
integrity really an issue?
of the lookup tables need to reside in the frontend database. The
data in the lookup fields that relate to the backend tables will never
change, but a descriptor for items in these fields will. I may need
to update the descriptors periodically, hence the need to keep these
tables in the frontend database so that the new descriptors will be
distributed with frontend updates.
Ideally the lookup fields should be linked to the backend tables with
referential integrity enforced. Because the tables are in 2 different
databases this can't be done.
What options do I have? Given that the lookup fields will always be
under my control and will never change, is enforcing referential
integrity really an issue?