This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
We started a good chatting on this other topic and I decided to make a new one more specific.
My apps are the following:
Operations and Logistics (Biggest one).
This is being driven with around 40 tables of different sizes and purposes. The main one, where everything is a children, grandchildren and more is containing a key concept called “Shipment”. This one is for each container that we dispached to other countries.
Quality Control (To be made).
This should use some of the data that was added to the DB from the Operations and Logistics one. 11 tables to be exact and at least 3 new ones should be created.
Finance (Half baked).
This is on a similar pattern that the 2nd but with less tables being reused. I haven’t checked as exactly as the 2nd but I think that around 8 tables from the first app are going to be used for this one.
Employee expenses (Done and one of the smallest of them).
This is independent from any other app.
ERP Launcher (Done, the smallest).
Similar to the 4th, this is independent and just serves as a launcher, it has 2 tables, one with the apps and another with the users to control which apps are available to each one.
The key points of the conversation that I wrote in the other topic are the following:
I need the convenience of having all in just one place. I would love to have every table for every app (considering the fact that we will have around 10 tables shared between apps) on a single workbook.
Are there really any performance issues?
Have you done it?
What’s your opinnion/suggestion around the “multiple apps, some tables shared” stuff?
Also, the shared tables mentioned on the 2nd and 3rd app just take input from the 1st one, on the 2nd and 3rd will be read only info
LinkedIn
Twitter
