Initially we had one native product database, several years ago an employee split it to multiple databases by product group (all same vendor, no duplicating MFG ID's). I am familiar with the con's of this current setup but wondering what "best practice" would be and if there are any benefits before I work to convert it back to all one database.
Heidi Bizub
Initially we had one native product database, several years ago an employee split it to multiple databases by product group (all same vendor, no duplicating MFG ID's). I am familiar with the con's of this current setup but wondering what "best practice" would be and if there are any benefits before I work to convert it back to all one database.