Hello all, I'm back with another question:
I have a list of about 37,000 codes (think similar to chart of accounts) that I have to include in EVERY report I do, so management can drill down by major account to minor accounts. It's my fault, really, I've got them used to having data at their fingertips.
Needless to say, I would prefer to store this as a Sharepoint table and then simply run lookups against it. Is this possible? Is there another way I can store this file in a central location and then just run lookups. Using a sharedrive is not possible as managers and customers are all on separate highly secured networks.
Thank you in advance for any thoughts.
I have a list of about 37,000 codes (think similar to chart of accounts) that I have to include in EVERY report I do, so management can drill down by major account to minor accounts. It's my fault, really, I've got them used to having data at their fingertips.
Needless to say, I would prefer to store this as a Sharepoint table and then simply run lookups against it. Is this possible? Is there another way I can store this file in a central location and then just run lookups. Using a sharedrive is not possible as managers and customers are all on separate highly secured networks.
Thank you in advance for any thoughts.