[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