[AccessD] Sort of like a filter only not

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



More information about the AccessD mailing list