Re: Database and Relationship Advice

Tech-Archive recommends: Fix windows errors by optimizing your registry

Why not just store the EventType in the Event table, rather than linking? A
combo box based on tblEventTypeID could be used to make the selection on the
EventType form, but each event will be of a single type. That is, one event
will not include a phone call and an e-mail, since those would be two
separate events. At least, that's how I understand the OP.

"Steve" <sorry@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:iak0i.9392$j63.7338@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
In TblCustomer, make CustomerID Autonumber. In TblEvent, make EventID
Autonumber, CustomerID Long Integer and EventTypeID Long Integer. I
inadvertently omitted a table you also need, TblEventTypeID, for recording
the types of events (call, email, etc.). Looks like this:
TblEventTypeID
EventTypeID
EventType
Make EventTypeID Autonumber. Join EventTypeID to EventTypeID in TblEvent.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx


"Claire" <Claire@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0B6A1562-29FF-4935-BC90-7ED26C9E91C9@xxxxxxxxxxxxxxxx
Thanks for both the replies.

Is it necessary to add in
EventID
EventTypeID
????

What will be the data type in these? Will i need to include these on a
form
or are they for linking purposes.

I had one relationship before and that was customer ID - Customer ID, do
I
have to link the other above also?

Kind Regards

Claire


"Steve" wrote:

TblCustomer
CustomerID
CustomerName
....
....


TblEvent
EventID
CustomerID
EventTypeID
EventDate
EventNote
....
....

Join CustomerID in TblCustomer to CustomerID in TblEvent.

Use a form/subform where the form is based on TblCustomer and the
subform is
based on TblEvent.


PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx





"Claire" <Claire@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F8065D2B-05D8-4F25-8D9E-8639DA25BA19@xxxxxxxxxxxxxxxx
PLEASE HELP

I am trying to produce a database that will allow me to store my
client
information and also log events such as telephone calls and and emails
when
they arrise. I have produced to tables so far a customer info table
and a
event log table but cannot get the information to transfer between the
two.
i.e When i look at a customer file then in a form, then click add new
event I
add it but then the same entry appears no matter what client I am on.
Please
can someone help me I have included the fields that I would like to
use
but
need a way to link them.

Customer Table and Events Table

Customer ID is currently being linked to Event ID in the event table
with
a
one to one relationship.

If anyone can take a look at these tables and suggest a better way to
separate and link I would much appreciate this and would be happy to
email
you this direct. I do feel that the one table is too large and would
like
to
separate it, but am having enough problems linking two tables, let
alone
more.

PLEASE YOUR HELP IS MUCH APPRECIATED










.

Quantcast