Re: Clients - internal and external, how design and process?

Gina,
Using even/odd numbers is a creative solution but inappropriate. Embedding
"hidden" information in a field is not good design practice as well as being
a violation of first normal form (all fields should be atomic). A better
solution is to create a new column that can be used to distinguish the two
different types of people. The new column is not limited to two choices,
should a third type of person be identified as the design progresses.
Pat

"Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message
news:%23X3CNiQ6HHA.5212@xxxxxxxxxxxxxxxxxxxxxxx
MSCeritfied,

Here's my two cents worth... Why not create a custom autonumbering field
that no one sees but you. IF you have a way to determine which ones are
external/internal, assign the external as odd numbers and the internal as
even numbers. This you have one table to create queries from and you have
a way to uniquely identify them.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"mscertified" <rupert@xxxxxxxxxxxxx> wrote in message
news:97F87F14-FA94-4515-BE73-D7C591E957E4@xxxxxxxxxxxxxxxx
My application must cater for internal and external clients. Internal
clients
are employees who are maintained in an existing table which is updated by
importing from another database (which I have no control over). External
clients are people outside the company. The information to be kept will
be
partly the same (name/address/phone no) but partly unique for internal or
external clients.
However, I will need treat these two types of client as a single entity
in
many queries and forms. What is the best way to set this up? I'm leaning
toward keeping the data in two separate tables but having a query that
draws
both together. However, this query will not have any common column to
uniquely identify the client and I can see that being a problem.




.

Relevant Pages

  • Re: Summarizing records in one table that match a different table
    ... the report. ... using "Language" as the example (i had to add a field to my Clients test ... i created a report based on the query with the joins ...
    (microsoft.public.access.reports)
  • Re: SP3 Inventory causing 100% CPU issues
    ... This new class added in SP3 collects auto run software information ... This class only collects auto run software information. ... can use wbemtest to find out which query caused the problem. ... at 100% cpu for hours causing the clients to be unusable since ...
    (microsoft.public.sms.admin)
  • RE: SMS 2003 Query Software Distribution Status
    ... noticed you had a query you didn't get working and started searching on ... Now that I see you wanted this for rerunning an advertisement I might as ... the advertisement only reruns on the failed clients. ... If you want to rerun on a single client, we can delete the job on an ...
    (microsoft.public.sms.admin)
  • Re: MySQL Connections buendeln
    ... Slow query log zeigt die ueblichen Queries wo halt viele dort drin stehen ... ich werd' das mal reduzieren um die Load lieber auf die Clients ...
    (de.comp.datenbanken.mysql)
  • Re: Caclulating Count of unique values
    ... Create a query into both tables. ... All clients, and any matching Orders. ... Drag ClientID from the Client table into the grid. ... In the Total row, accept Group By under this field. ...
    (microsoft.public.access.modulesdaovba)