Company Contacts

I am making a database for a call center so they can look up people,
companies and the duties that these contacts are responsible for so they can
refer problems to the right people or give out correct adresses, numbers etc
to our customers. Right now all the information is very unaccessable and you
are on your own to gather this info.
So far I have come up with that I have a main table - Company and the primary
key for this is the company name. My reasoning is that I never want to veiw a
report in the future with the possbility that it might show the value instead
of the name and - this is a unique field. There will be no duplicates.
My subforms are:
Department and it's subform is
Group/Team/ Division.

My problem is I need to add people to these groups. Not every company will
have a department or group the people will simply be under co.
The majority of my contacts will. This table is mostly for contacting people
within our company and we have many divisions.
I could have a subform for each breakdown- ie- company with a subform, dept
with a subform etc.
But when I want to be able to search for a person and view there info I would
have to do a search under each group and that is too time consuming for a
person who has to find info quickly. Also I need to use an expression base on
all the people to fill in the - 'Who is in charge of this group field'

Also- Each person has duties and (this is the most useful part of this
database). Each person in our co. has things others need to refer to them and
a certain way to refer to them. We get emails daily as to how to refer a
customer issue to a certain person. This database is a way to update this
info and add the person resposible for this. The call center needs to enter
a key word and be able to see be able to see who is responsible for this and
the field that has instructions for how to refer this to them.


Sorry this is long but I have tried at least three mock ups of this type of
database and have encounter a major problem with some aspect of it. Thanks
in advance!

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Company Contacts
    ... I could have a subform for each breakdown- ie- company with a subform, ... Each person in our co. has things others need to refer to them ... This database is a way to update this ... a key word and be able to see be able to see who is responsible for this ...
    (microsoft.public.access.tablesdbdesign)
  • Re: NorthWind Traders Question/Problem
    ... When a form is opened as a subform, it is not considered to be "open". ... refer to it, you have to take a path through the main form. ... SubformControl refers to a control on the main form. ... > NorthWind Traders Database that lists Categories and then limits the ...
    (microsoft.public.access.forms)
  • Re: access crashes when form is filtered
    ... Compact the database to get rid of this junk: ... Uncheck any references you do not need. ... >> form has a subform, the crash could be due to this bug. ...
    (microsoft.public.access.forms)
  • Re: #Error - Bookmark Invalid
    ... I'm assuming you have split this database so that everyone has an ... > it helps to set the Format property of all calculated text boxes that are ... If your subform has no records and no new records can be added (e.g. ... > calculations keep retriggering. ...
    (microsoft.public.access.forms)
  • Re: update query
    ... structure of the database. ... I made a subform, using the tools on the left side, to make a subform ... pointing to the Transaction data base, bookbarcode, studentID, date- ... barcode - primary key ...
    (microsoft.public.access.queries)