SP1KEMAG00
SP1KEMAG00 at aol.com
Fri Dec 12 18:25:48 CST 2003
Andy, How about storing all your customer data in one master table and have an option to extract only the data for the current customer into a table your queries/forms then use? Shaun -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: 12 December 2003 15:16 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Sort of like a filter only not Not sure what you mean by "mixed up" Gustav. Take one of many screens. Here you can select a financial period and year; select a customer or a customer group or leave blank for all customers, hit Print and a report will show the orders for those criteria, a summary of expenditure, render it into GBP if it was export and so on. And that's just one of many, many examples. Now the pitfalls are that a) the sales person may/will drop down the combo to choose the customer, thereby showing other customers or b) may inadvertently select the wrong customer and print the report (and hand it over to his client before he realises his mistake - aargh!) or c) hit Print without selecting a customer and therefore list activity for all customers. This is the sort of thing I'm talking about. And as I stressed right from the start there are oodles of such situations in the system so attacking each one individually is not an option. At the moment I like your idea Gustav of deliberately "corrupting" the rest of the data so that it's there but unrecognisable. If I did that to selected fields (names, addresses, phone nos, email addresses and so - not too many I don't think) I think that would do nicely. I guess I could even do it by encryption so that it's reversible. That way my on-the-road salesperson could "corrupt" all but one customer, then un-corrupt all after first meeting and re-corrupt all but a second customer when they get to the next place. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Sort of like a filter only not Date: 12/12/03 13:44 Hi Andy Hmmm ... but why are the data initially mixed up? /gustav > Sorry, reading my original again I may have misled you Jim. We're not > talking about a situation where a customer permanently has a system > with their data on it. We're talking about situations such as customer > A coming to these premises for a meeting for a day and my client > wanting to be able to show them the system on-screen but limited only > to their data, OR a sales > person going travelling with a laptop onto which we have downloaded > the system (this we do already - for enquiry purposes only) and having meetings > with several customers over several days. So we need to be able, > fairly quickly, to say "I'm going into a meeting with X so make the > system show only X and Y's data (where Y is X's sister company)". _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com