Can I am Desiging a database for an ERP application. It has 3 modules: FM, MRP, HR. Can I design the tables for each of the module separately and then combine all of the things together.(triggers too). If yes then how to combine them? Please let me now.
Just one added suggestion--if you want to change one of the tables but keep the data in the other table unchanged, you can add a Make Table query to the second database to effectively archive the original data. For example this may be useful for maintaining quarterly financial records in the ERP application, or for periodic snapshots of the HR or other databases.