Hey,

I have to store a history of different entities (pc's, servers, ...)

For instance:
entity: pc15
date event
1/10/03 software update
5/12/03 new hard drive
....

How can I store this in access? What would the table look like? I had put a
date and an event field in my history table, but then I could only store 1
event... I could put 10 dates and events, but I since I don't know how many
events will happen to an entity, I'm a little lost...

Thanks,
Oswald

You need one table for your "entities" and another for your event history..

eg

tblEntity
-----------
EntityID Autonumber
EntityName Text

tblHistory
-------------
EntityID Number (Long)
HistoryTimestamp Date/Time ( default = Now() )
HistoryNotes Memo

Then create a relationship between the two tables on the EntityID field.
(one to many)

Hope that gives you a start....

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

"Oswald" <fluffster71 (AT) hotmail (DOT) com> wrote

Yes,

but there are different tables with entities... tblPc's, tblServers,
tblHubs, ... all of the servers or pc's or... have a history... so do I have
to link every table to my history table? Because if I do that, whenever I
try to log an event in my history table for a pc, it will tell me that there
are no corresponding records in servers or hubs... (referential integrity)

Do I have to not use referential integrity, or make an instance of
tblHistory for every table I want to link to it?

Thanks,
Oswald


"Bradley" <bradley (AT) REMOVETHIScomcen (DOT) com.au> wrote

Why do you need to separate each entity into a separate table? Why not just
add a field called EntityType? (and perhaps make your other fields more
generic?)

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response


"Oswald" <fluffster71 (AT) hotmail (DOT) com> wrote

Hey,

because I need to store a shitload of information about every entity, not
just a history.

The history is just a little extra. So I now have a PC form with al the info
and a subform history with all the 'historylines'. But whenever I enter a
new event in a historyline, it says there is no related field in servers,
and vice versa... Can I just not use referential integrity between the
history table and the other entitytables? Or do I have to use a referential
integrity relationship between different instances of the history table?

I hope this makes sense... I don't know all the exact words in English...

Thanks so far,
Oswald


"Bradley" <bradley (AT) REMOVETHIScomcen (DOT) com.au> wrote

Hey,

tried the different instances of the same table, but that doesn't work...
guess I need to lose the ref integrity then?

Oswald


"Oswald" <fluffster71 (AT) hotmail (DOT) com> wrote

Hi Oswald,

It seems you are just starting to creat a database. The following articles
maybe helpfull when you want to design a database.

http://support.microsoft.com/search/...false&numDays=

Goodluck!

Sid.

"Oswald" <fluffster71 (AT) hotmail (DOT) com> schreef in bericht
news:3fa51c24$0$1869$ba620e4c (AT) reader0 (DOT) news.skynet.be...

Hey,

I have deleted all my relationships and used vb.net to access my database.
It works now. Guess it just wasn't possible in access.

Thanks,
Oswald

From: "Oswald" <fluffster71 (AT) hotmail (DOT) com>
Subject: Re: Storing data
Date: woensdag 5 november 2003 21:19

Hey,

tried the different instances of the same table, but that doesn't work...
guess I need to lose the ref integrity then?

Oswald


"Oswald" <fluffster71 (AT) hotmail (DOT) com> wrote

Are you setting the value of the ID field for each history line?

I usually setup the DefaultValue to get the parent table ID automatically
from a form for each new record.

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

"Oswald" <fluffster71 (AT) hotmail (DOT) com> wrote